I have a scenario where we are doing an application release and they want to be
able to potentially rollback to HA if things go bad. So the current process
would be:
1. Run select pg_xlog_replay_pause(); on standby to pause replication
2. Apply changes
3. If team needs to revert to old
.
Brian
-Original Message-
From: Bellrose, Brian
Sent: Tuesday, February 18, 2020 5:07 PM
To: Adrian Klaver ;
pgsql-general@lists.postgresql.org
Subject: RE: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1
I found a repository that offered it and added the repo.
https
Thanks for the info. I will investigate these steps.
Brian
-Original Message-
From: Giulio Calacoci
Sent: Wednesday, February 19, 2020 9:07 AM
To: Bellrose, Brian
Cc: Adrian Klaver ;
pgsql-general@lists.postgresql.org
Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap
. Going to
use pglogical to try and reduce downtime.
Brian
-Original Message-
From: Adrian Klaver
Sent: Tuesday, February 18, 2020 5:00 PM
To: Bellrose, Brian ;
pgsql-general@lists.postgresql.org
Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1
On 2/18/20 1:56 PM
, 2020 4:41 PM
To: Bellrose, Brian ;
pgsql-general@lists.postgresql.org
Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1
On 2/18/20 1:22 PM, Bellrose, Brian wrote:
> I used zypper to install postgres. Postgres is fine... Running 9.4.25 that I
> updated today. So you hav
, 2020 4:19 PM
To: Bellrose, Brian ;
pgsql-general@lists.postgresql.org
Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1
On 2/18/20 12:54 PM, Bellrose, Brian wrote:
> Yes, I understand that this OS is very old. I can't help that. I was handed
> this. The reason
rst and it did not work. I have gotten farther with 2.2.0, but I am getting
what appears to be dependency errors. Might need to install krb5-devel. Not
100% clear though.
Brian
-Original Message-
From: Adrian Klaver
Sent: Tuesday, February 18, 2020 3:49 PM
To: Bellrose, Brian ;
pgs
In the process of trying to use pglogical to upgrade from 9.4 to 11.7. Current
OS is openSUSE Leap 42.1. Downloaded pglogical-2.2.0.tar from 2nsQuadrant site.
I am getting the following error during make clean all command:
o pglogical_worker.c
In file included from pglogical_worker.c:17:0:
/usr/
