Re: Pg_auto_failover

From: Rene Romero Benavides <rene(dot)romero(dot)b(at)gmail(dot)com>
To: Sonam Sharma <sonams1209(at)gmail(dot)com>
Cc: Paul Jungwirth <pj(at)illuminatedcomputing(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Pg_auto_failover
Date: 2019-09-30 16:39:57
Message-ID: CANaGW0_cjuYF8+e9x0UP_gRuH1bZygbuyk0A6GBMUdWYONVJBQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)gmail(dot)com> 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(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
>>
>>
>>

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Salisbury 2019-09-30 18:23:27 Re: Arrays and ANY problem
Previous Message Marco Ippolito 2019-09-30 16:21:56 Re: "Failed to connect to Postgres database" : No usage specified for certificate (update)