Re: Pg_auto_failover

Thanks Paul, I am able to set up. Does pg_auto_failover only works on v10
and v11.
I am having 9.5 on production.

On Wed, Sep 25, 2019, 11:40 PM Paul Jungwirth <pj(at)illuminatedcomputing(dot)com>
wrote:

> On 9/25/19 8:55 AM, Sonam Sharma wrote:
> > 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
>
> In addition to the code already linked to, I would look at
>
> https://github.com/citusdata/pg_auto_failover/blob/1290edd0bab54c627f577cf4462bd16a56b20a1a/src/bin/pg_autoctl/pgctl.c#L429-L437
>
> You see that pg_auto_failover is trying to `mkdir -p $pgdata/../backup`
> (where pgdata is a C variable, not a shell/environment variable). You
> might want to read through the rest of that code to see where pgdata is
> coming from, and see if it's being set correctly. Do you really want
> /backup at the root level?
>
> Clearly whatever user is running pg_basebackup doesn't have permission
> to make that directory. But maybe that's okay and the directory should
> be somewhere else.
>
> --
> Paul ~{:-)
> pj(at)illuminatedcomputing(dot)com
>
>
>