Re: pg_basebackup permission denied error

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(at)gmail(dot)com>
wrote:

>
>
> On Thu, Nov 9, 2017 at 6:27 AM, Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
> wrote:
>
>>
>>
>> On Thu, Nov 9, 2017 at 6:16 AM, Günce Kaya <guncekaya14(at)gmail(dot)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 <https://tr.linkedin.com/in/guncekaya> - Twitter
>>> <https://twitter.com/gguncesi> - Blog
>>> <http://www.guncekaya.blogspot.com.tr/>
>>>
>>
>> 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.
>
> https://shreeyansh.com/
> [image: http://www.shreeyansh.com] <http://www.shreeyansh.com>
>

--
Gunce Kaya

Linkedin <https://tr.linkedin.com/in/guncekaya> - Twitter
<https://twitter.com/gguncesi> - Blog
<http://www.guncekaya.blogspot.com.tr/>