Re: pg_basebackup permission denied error

On Thu, Nov 9, 2017 at 8:07 AM, Günce Kaya <guncekaya14(at)gmail(dot)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(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.
>>
>> [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/>
>

--

[image: http://www.shreeyansh.com] <http://www.shreeyansh.com>