Re: upgrades and streaming replication - Mailing list pgsql-admin

From Grant Fisher
Subject Re: upgrades and streaming replication
Date
Msg-id CAEcvs9Hd3Rm-3Q8D7PqPo98ffRLNqP_nYMsXG3Zf_DQRMJCcsA@mail.gmail.com
Whole thread Raw
In response to upgrades and streaming replication  (Charles Sprickman <spork@biglist.com>)
List pgsql-admin
On Tue, Sep 10, 2013 at 10:13 PM, 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.
<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

pgsql-admin by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Dumping a database that is not accepting commands?
Next
From: Thara Vadakkeveedu
Date:
Subject: accidentally deleted data directory