Re: Pg_auto_failover - Mailing list pgsql-general

On Tue, Sep 24, 2019 at 8:41 AM Sonam Sharma <sonams1209@gmail.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)