Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] pg_basebackup permission denied error - Mailing list pgsql-admin

From Günce Kaya
Subject Re: [ADMIN] pg_basebackup permission denied error
Date
Msg-id CAAV2-mWG+4g5ZTQMpDbCy9TcO4PN+C1-qae=EBWpu-bMxW5m6g@mail.gmail.com
Whole thread Raw
In response to Re: [ADMIN] pg_basebackup permission denied error  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
Responses Re: [ADMIN] pg_basebackup permission denied error  (Gokhan Demir <demirgokhan@gmail.com>)
Re: [ADMIN] pg_basebackup permission denied error  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
List pgsql-admin
Tree view
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 by date:

Previous
From: Shreeyansh Dba
Date:
Subject: Re: [ADMIN] Can master and slave on different PG versions?
Next
From: Gokhan Demir
Date:
Subject: [ADMIN] PostgreSQL WAL file issue