Re: Pg_auto_failover

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 wrote: >

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 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 check

Re: Pg_auto_failover

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

Re: Pg_auto_failover

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 On Wed, Sep 25, 2019, 12:15 AM bricklen wrote: > > > On Tue, Sep 24, 2019 at 8:41 AM Sonam Sharma wrote: > >> I was setting up pg_auto_failover. Have

Re: Pg_auto_failover

On Tue, Sep 24, 2019 at 8:41 AM Sonam Sharma 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 initi

Re: Pg_auto_failover

Hi Rob, I have no where mentioned /backup. I have manually create backup inside / folder to check why it's giving the error. The /backup folder is empty only. On Tue, Sep 24, 2019, 11:15 PM Rob Sargent wrote: > > > > On Sep 24, 2019, at 11:38 AM, Sonam Sharma wrote: > > > > Hi Rob, > > Os :

Re: Pg_auto_failover

> On Sep 24, 2019, at 11:38 AM, Sonam Sharma wrote: > > Hi Rob, > Os : Linux rhel x86_64 > Postgres version : 11.2 > Installed the rpm of pg_auto_failover and then set up the monitor, primary. > Secondary is failing with given error > Well //backup is a valid reference to /backup (double sl

Re: Pg_auto_failover

Hi Rob, Os : Linux rhel x86_64 Postgres version : 11.2 Installed the rpm of pg_auto_failover and then set up the monitor, primary. Secondary is failing with given error On Tue, Sep 24, 2019, 10:11 PM Rob Sargent wrote: > > > > On Sep 24, 2019, at 9:41 AM, Sonam Sharma wrote: > > > > I was sett

Re: Pg_auto_failover

> On Sep 24, 2019, at 9:41 AM, Sonam Sharma 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

Re: Pg_auto_failover

> On Sep 24, 2019, at 10:22 AM, Sonam Sharma wrote: > > Can someone please help > > -- Forwarded message - > From: Sonam Sharma mailto:sonams1...@gmail.com>> > Date: Tue, Sep 24, 2019, 9:11 PM > Subject: Pg_auto_failover > To: pgsql-general

Re: Pg_auto_failover

On 9/23/19 10:38 AM, Sonam Sharma wrote: I have installed the PostgreSQL 11 from source.(untarred the file and then make install as postgres user since we don't have root access) . Can you please help in installing the extension for pg_auto_failover.. is it possible as postgres user only ?? F

Re: Pg_auto_failover

I have installed the PostgreSQL 11 from source.(untarred the file and then make install as postgres user since we don't have root access) . Can you please help in installing the extension for pg_auto_failover.. is it possible as postgres user only ?? Thanks, Sonam On Wed, Sep 18, 2019, 8:31 PM Ad

Re: Pg_auto_failover

On 9/18/19 7:56 AM, Sonam Sharma wrote: Adrian, Postgres version : 10.7 Os version : Linux Redhat 7.4 If you are installing from the PGDG repos then the package is there: https://yum.postgresql.org/10/redhat/rhel-7-x86_64/repoview/pg_auto_failover_10.html You can also go here: https://gith

Re: Pg_auto_failover

Adrian, Postgres version : 10.7 Os version : Linux Redhat 7.4 On Wed, Sep 18, 2019, 8:01 PM Adrian Klaver wrote: > On 9/18/19 7:19 AM, Sonam Sharma wrote: > > Can someone please guide me in installing pg_auto_failover.. where can I > > get the rpm package for this ? > > > OS and version? > > Po

Re: Pg_auto_failover

On 9/18/19 7:19 AM, Sonam Sharma wrote: Can someone please guide me in installing pg_auto_failover.. where can I get the rpm package for this ? OS and version? Postgres version? -- Adrian Klaver adrian.kla...@aklaver.com