Re: [ADMIN] pg_basebackup permission denied error

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

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?

For more details please go through the below link provided.

https://www.postgresql.org/docs/current/static/app-pgbasebackup.html

 

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

Linkedin - Twitter - Blog

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

Linkedin - Twitter - Blog

--