Re: 9.5 beta pg_upgrade documentation - Mailing list pgsql-general

From Andy Colson
Subject Re: 9.5 beta pg_upgrade documentation
Date
Msg-id 55D9DC9E.8080806@squeakycode.net
Whole thread Raw
In response to 9.5 beta pg_upgrade documentation  (Andy Colson <andy@squeakycode.net>)
Responses Re: 9.5 beta pg_upgrade documentation
List pgsql-general
I think we should add a step 6.5 (before step 7 Stop both servers) with something like:

If you are upgrading both a primary and standby, then we need to make sure the standby is caught up.
If you are wal shipping then on primary run: select pg_switch_xlog();
shut down primary
before you shut down the standby make sure it gets caught up to the primary.

I don't think its 100% required for them to be exact, is it?  If they are a little different then rsync has more data
toxfer from primary to standby ... but it would still work.  Right? 

-Andy


pgsql-general by date:

Previous
From: s d
Date:
Subject: Re: Problem with pl/python procedure connecting to the internet
Next
From: Adrian Klaver
Date:
Subject: Re: Problem with pl/python procedure connecting to the internet