Search Postgresql Archives

Re: Pg_auto_failover

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



It seems it does, only 10 and 11 as of this:
"We support Postgres 10 and Postgres 11. "
https://cloudblogs.microsoft.com/opensource/2019/05/06/introducing-pg_auto_failover-postgresql-open-source-extension-automated-failover-high-availability/

On Sat, Sep 28, 2019 at 8:44 AM Sonam Sharma <sonams1209@xxxxxxxxx> wrote:
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@xxxxxxxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxxxxxxx




--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux