Subject: Re: 9.5 beta pg_upgrade documentation
To: pgsql-general@postgresql.org
References: <55D789B5.7040308@squeakycode.net>
From: Andy Colson <andy@squeakycode.net>
Message-ID: <55D9DC9E.8080806@squeakycode.net>
Date: Sun, 23 Aug 2015 09:45:50 -0500
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:38.0) Gecko/20100101
 Thunderbird/38.2.0
MIME-Version: 1.0
In-Reply-To: <55D789B5.7040308@squeakycode.net>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

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 to xfer from primary to standby ... but it would still work.  Right?

-Andy


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general