Question on pg_auto_failover extension

2022-06-29 Thread DAN LU
Hello, I ran into issue with creating the monitor server using the pg_auto_failover extension. I outlined the issue here: https://github.com/citusdata/pg_auto_failover/issues/912 Any feedback or help is greatly appreciated.

Re: Pg_auto_failover

2019-09-30 Thread Rene Romero Benavides
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 Sha

Re: Pg_auto_failover

2019-09-28 Thread Sonam Sharma
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

Re: Pg_auto_failover

2019-09-25 Thread Paul Jungwirth
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

Re: Pg_auto_failover

2019-09-25 Thread Sonam Sharma
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_a

Re: Pg_auto_failover

2019-09-24 Thread Sonam Sharma
> > 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 slash si

Re: Pg_auto_failover

2019-09-24 Thread Rob Sargent
> 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 refe

Re: Pg_auto_failover

2019-09-24 Thread Sonam Sharma
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 wrot

Re: Pg_auto_failover

2019-09-24 Thread Rob Sargent
> 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"

Re: Pg_auto_failover

2019-09-24 Thread Rob Sargent
> 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:

Fwd: Pg_auto_failover

2019-09-24 Thread Sonam Sharma
Can someone please help -- Forwarded message - From: Sonam Sharma Date: Tue, Sep 24, 2019, 9:11 PM Subject: Pg_auto_failover To: pgsql-general I was setting up pg_auto_failover. Have successfully set up and monitor and primary instance. While setting up secondary it's failing

Pg_auto_failover

2019-09-24 Thread Sonam Sharma
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 initialise standby server , see above for detai

Re: Pg_auto_failover

2019-09-23 Thread Adrian Klaver
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

Re: Pg_auto_failover

2019-09-23 Thread Sonam Sharma
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

pg_auto_failover

2019-09-20 Thread Bhardwaj, SONAM- SONAM R
Hi, When I am setting up keeper , [postgres@lablnxdb001 ~]$ pg_autoctl run --pgdata /opt/primary 08:51:03 INFO Managing PostgreSQL installation at "/opt/primary" 08:51:03 INFO PostgreSQL is running in "/opt/primary" on port 6433 08:51:03 ERROR default_version or installed_version for extension

Fwd: FW: pg_auto_failover

2019-09-20 Thread Sonam Sharma
Hi, When I am setting up keeper , [postgres@lablnxdb001 ~]$ pg_autoctl run --pgdata /opt/primary 08:51:03 INFO Managing PostgreSQL installation at "/opt/primary" 08:51:03 INFO PostgreSQL is running in "/opt/primary" on port 6433 08:51:03 ERROR default_version or installed_version for

Re: Pg_auto_failover

2019-09-18 Thread Adrian Klaver
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

Pg_auto_failover

2019-09-18 Thread Sonam Sharma
Can someone please guide me in installing pg_auto_failover.. where can I get the rpm package for this ?