Re: pg_basebackup permission denied error

[Günce Kaya <guncekaya14@xxxxxxxxx>]

Hi all,

Problem was resolved. I'm sending this mail for recording. 

I added /data folder under / directory as root user and changed permission to 700, changed owner as Postgres. After that I run pg_basebackup command. So, it works now.

Best regards,

Günce 

On Thu, Nov 9, 2017 at 11:04 AM, Shreeyansh Dba <shreeyansh2014@xxxxxxxxx> wrote:

On Thu, Nov 9, 2017 at 8:07 AM, Günce Kaya <guncekaya14@xxxxxxxxx> 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@xxxxxxxxx> wrote:

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

On Thu, Nov 9, 2017 at 6:16 AM, Günce Kaya <guncekaya14@xxxxxxxxx> 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

--

--

Gunce Kaya

Linkedin - Twitter - Blog