From: | Stephen Frost <sfrost(at)snowman(dot)net> |
---|---|
To: | Don Seiler <don(at)seiler(dot)us> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Upgrade master/slave: rsync? |
Date: | 2017-09-13 16:24:13 |
Message-ID: | 20170913162413.GX4628@tamriel.snowman.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Don,
* Don Seiler (don(at)seiler(dot)us) wrote:
> Planning steps to upgrade our 9.2 DB to the latest stable 9.6 using
> pg_upgrade. I've gone through the steps for a primary/standalone DB and
> they work well. Looking into how then to upgrade the standby, the
> documentation says that *the data_dir from the master should be rsync'ed to
> each slave*.
>
> Is this truly the case? Having to copy all the data from the primary will
> be a huge issue for our larger databases. I had hoped we'd just need to
> upgrade the binaries, copy the old data dir to the new data dir, update
> conf files as needed and turn it back on (similar to Oracle standby
> upgrade).
There is a method to avoid having to copy the data from the primary, but
it requires using --link mode with pg_upgrade and it's a bit of an
involved process that requires very carefully following the steps and
doing additional validation.
A discussion around exactly this is currenlty ongoing as to how we can
improve the documentation on this method. You can find that discussion
here:
Thanks!
Stephen
From | Date | Subject | |
---|---|---|---|
Next Message | Don Seiler | 2017-09-13 16:50:00 | Re: Upgrade master/slave: rsync? |
Previous Message | Guillaume Lelarge | 2017-09-13 16:13:32 | Re: Upgrade master/slave: rsync? |