From: | Grant Fisher <gfisher(at)pecanstreet(dot)org> |
---|---|
To: | Charles Sprickman <spork(at)biglist(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: upgrades and streaming replication |
Date: | 2013-09-20 17:26:31 |
Message-ID: | CAEcvs9Hd3Rm-3Q8D7PqPo98ffRLNqP_nYMsXG3Zf_DQRMJCcsA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Tue, Sep 10, 2013 at 10:13 PM, Charles Sprickman <spork(at)biglist(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Thara Vadakkeveedu | 2013-09-22 16:05:33 | accidentally deleted data directory |
Previous Message | Kevin Grittner | 2013-09-18 22:03:06 | Re: Dumping a database that is not accepting commands? |