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/
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) |