Обсуждение: upgrades and streaming replication
I just wanted to check if there are any updates on the preferred way to upgrade a group of servers that are using streamingreplication with minimal downtime. Mailing list messages from a year or two ago pretty much state the following: * No current plans to come up with some new mechanism to automate this process, downtime is assumed. * If you want no downtime, use one of the userspace replication solutions. * Best option is to upgrade the master with pg_upgrade, then upgrade the slaves and re-copy your data. * While it's tempting to think you could just run pg_upgrade on all hosts to avoid the copy step, that will not work as somethingin the system catalog changes which will break replication. * No good options to speed up the slave copy - rsync will either use timestamps to figure out if a file changed (and streamingskews that), or checksumming (and checksumming is slow). Is that still pretty much the situation today with 9.2 and 9.3? Any good guides or BCPs for the standard procedure that emphasize limiting downtime and giving a good rollback path? Thanks, Charles
On Wed, Sep 11, 2013 at 8:43 AM, Charles Sprickman <spork@biglist.com> wrote:
I just wanted to check if there are any updates on the preferred way to upgrade a group of servers that are using streaming replication with minimal downtime.
Mailing list messages from a year or two ago pretty much state the following:
* No current plans to come up with some new mechanism to automate this process, downtime is assumed.
* If you want no downtime, use one of the userspace replication solutions.
* Best option is to upgrade the master with pg_upgrade, then upgrade the slaves and re-copy your data.
* While it's tempting to think you could just run pg_upgrade on all hosts to avoid the copy step, that will not work as something in the system catalog changes which will break replication.
* No good options to speed up the slave copy - rsync will either use timestamps to figure out if a file changed (and streaming skews that), or checksumming (and checksumming is slow).
Is that still pretty much the situation today with 9.2 and 9.3?
Any good guides or BCPs for the standard procedure that emphasize limiting downtime and giving a good rollback path?
Below URL provides more information about the list of PostgreSQL Up-gradation methods:
--Raghu
On Tue, Sep 10, 2013 at 10:13 PM, Charles Sprickman <spork@biglist.com> wrote:
I am also concerned about upgrading our 9.2 servers which are set up using streaming replication. I would prefer not to copy the data over via rsync, since that is pretty time consuming. Does anybody know if there any other options to do an in-place upgrade?
I just wanted to check if there are any updates on the preferred way to upgrade a group of servers that are using streaming replication with minimal downtime.
<snip>
* No good options to speed up the slave copy - rsync will either use timestamps to figure out if a file changed (and streaming skews that), or checksumming (and checksumming is slow).
<snip>
Is that still pretty much the situation today with 9.2 and 9.3?
Charles,
I am also concerned about upgrading our 9.2 servers which are set up using streaming replication. I would prefer not to copy the data over via rsync, since that is pretty time consuming. Does anybody know if there any other options to do an in-place upgrade?
Thanks,
Grant