Goal - having 1 master and 2 standbies - make switchover in the way , that
except minimal downtime - there was always 1 running master and 2 warm
standbies.
Lets say i have 3 hosts (1,2,3) , 1 master and 2 warm standbies . ( M1 SB2
SB3)
Each SB gets (Master rsyncs from his side to SB) archived
Sounds like you're using a newer version of psql to connect to the older
host.
psql 8.2.4 would throw up errors like that when connecting to a 7.4.7 box -
when you login to the old box, then run psql, you would be running the old
version of psql and hence the error disappears.
Cheers,
~p
I'm preparing to upgrade a 7.4.7 DB to 8.2.4.
I just got connectivity from new to old (different hosts), and being
a newhire and no-one had ever done any maintenance on the old DB, I
connected as joe-user to the old DB using the client of the new.
(joe-user is the owner of the DB)
I did
On Thu, 2 Aug 2007, Ralph Smith wrote:
I'm preparing to upgrade a 7.4.7 DB to 8.2.4.
I just got connectivity from new to old (different hosts), and being
a newhire and no-one had ever done any maintenance on the old DB, I
connected as joe-user to the old DB using the client of the new.