Re: upgrades and streaming replication

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

In response to

Browse pgsql-admin by date

  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?