Re: [ADMIN] pg_basebackup permission denied error

Поиск
Список
Период
Сортировка
От Günce Kaya
Тема Re: [ADMIN] pg_basebackup permission denied error
Дата
Msg-id CAAV2-mWG+4g5ZTQMpDbCy9TcO4PN+C1-qae=EBWpu-bMxW5m6g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [ADMIN] pg_basebackup permission denied error  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
Ответы Re: [ADMIN] pg_basebackup permission denied error
Re: [ADMIN] pg_basebackup permission denied error
Список pgsql-admin
Дерево обсуждения
Hi again,

I have created rep user like;

CREATE USER rep REPLICATION LOGIN ENCRYPTED PASSWORD 'xxxx';

So, user having replication permission. Maybe I miss something about this situation. Is there anything additional for that?

Regards,
Gunce

On Thu, Nov 9, 2017 at 8:49 AM, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:


On Thu, Nov 9, 2017 at 6:27 AM, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:


On Thu, Nov 9, 2017 at 6:16 AM, Günce Kaya <guncekaya14@gmail.com> wrote:
Hello,

I'm getting error when using pg_basebackup as bellow;

pg_basebackup: could not create directory "/data": Permission denied

I couldn't overcome with that problem. Any suggestion would be appreciated.

Regards,
Gunce Kaya


Hi Gunce Kaya,


/data -- directory requires postgres user permission.

In addition to this, the user might not be a valid DB user having enough privileges in order to perform backup having entry in pg_hba file.




--
Gunce Kaya

В списке pgsql-admin по дате отправления:

Предыдущее
От: Shreeyansh Dba
Дата:
Сообщение: Re: [ADMIN] Can master and slave on different PG versions?
Следующее
От: Gokhan Demir
Дата:
Сообщение: [ADMIN] PostgreSQL WAL file issue