Re: Pg_auto_failover

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)