Re: Pg_auto_failover

From: Sonam Sharma <sonams1209(at)gmail(dot)com>
To: bricklen <bricklen(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Pg_auto_failover
Date: 2019-09-25 15:55:09
Message-ID: CAM-M3TmDbc1rLnToXHAfN0_BLkdtDXk-6oxckVNMo8xLcf5n7w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

My user has permission to touch inside the Fs.
I am not getting why it is checking for /backup.

Any suggestions on this , what else I can check

On Wed, Sep 25, 2019, 12:15 AM bricklen <bricklen(at)gmail(dot)com> wrote:

>
>
> On Tue, Sep 24, 2019 at 8:41 AM Sonam Sharma <sonams1209(at)gmail(dot)com> wrote:
>
>> I was setting up pg_auto_failover. Have successfully set up and monitor
>> and primary instance. While setting up secondary it's failing with below :
>>
>> ERROR Failed to ensure empty directory "//backup" : Permission denied
>> Error Failed initialise standby server , see above for details.
>>
>
> If you're using the tool from Citus, per
> https://github.com/citusdata/pg_auto_failover/blob/d8ba26f47a60eaf1e1dc63ae67279553984d84f5/src/bin/pg_autoctl/file_utils.c#L112
> Is the problem literally that the OS user executing the commands does not
> have sufficient permission to work in that directory? If you are creating
> your data directory manually in "/", you might want to create a directory
> under that path that the user executing the commands has sufficient
> permission to modify (delete, create, write to)
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-09-25 16:00:39 Re: Upgrading old server
Previous Message Ron 2019-09-25 15:37:36 Re: Upgrading old server