pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUpgrading from 9.1 to 9.2 - master AND slave
3+ messages / 3 participants
[nested] [flat]
* Upgrading from 9.1 to 9.2 - master AND slave
@ 2013-07-10 21:14 Wells Oliver <wellsoliver@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Wells Oliver @ 2013-07-10 21:14 UTC (permalink / raw)
To: pgsql-admin
Following up to my earlier post: I have a master and a slave server (using
WAL), both 9.1. My 9.2 upgrade process is:
1) stop postgres on both servers
2) run pg_upgrade --link on both servers
3) change ports so 9.2 is on 5432, 9.1 on 5433
4) restart
Is this the best way to do it and ensure that the WAL is still being
created and the master/slave relationship properly maintained?
Thanks.
--
Wells Oliver
wellsoliver@gmail.com
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Upgrading from 9.1 to 9.2 - master AND slave
@ 2013-07-15 04:31 Sergey Konoplev <gray.ru@gmail.com>
parent: Wells Oliver <wellsoliver@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Sergey Konoplev @ 2013-07-15 04:31 UTC (permalink / raw)
To: Wells Oliver <wellsoliver@gmail.com>; +Cc: pgsql-admin
On Wed, Jul 10, 2013 at 2:14 PM, Wells Oliver <wellsoliver@gmail.com> wrote:
> Following up to my earlier post: I have a master and a slave server (using
> WAL), both 9.1. My 9.2 upgrade process is:
>
> 1) stop postgres on both servers
> 2) run pg_upgrade --link on both servers
> 3) change ports so 9.2 is on 5432, 9.1 on 5433
> 4) restart
>
> Is this the best way to do it and ensure that the WAL is still being created
> and the master/slave relationship properly maintained?
The problem is that after pg_upgrade the system catalog on the servers
wont match. Therefore you need to rebuild your slave from scratch.
There were some ideas around rsync [1], however, nobody proved that
they work appropriately.
[1] http://www.postgresql.org/message-id/20120320204916.GB26163@momjian.us
--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA
Profile: http://www.linkedin.com/in/grayhemp
Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979
Skype: gray-hemp
Jabber: gray.ru@gmail.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Upgrading from 9.1 to 9.2 - master AND slave
@ 2013-07-16 09:58 Bruce Momjian <bruce@momjian.us>
parent: Sergey Konoplev <gray.ru@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Bruce Momjian @ 2013-07-16 09:58 UTC (permalink / raw)
To: Sergey Konoplev <gray.ru@gmail.com>; +Cc: Wells Oliver <wellsoliver@gmail.com>; pgsql-admin
On Sun, Jul 14, 2013 at 09:31:16PM -0700, Sergey Konoplev wrote:
> On Wed, Jul 10, 2013 at 2:14 PM, Wells Oliver <wellsoliver@gmail.com> wrote:
> > Following up to my earlier post: I have a master and a slave server (using
> > WAL), both 9.1. My 9.2 upgrade process is:
> >
> > 1) stop postgres on both servers
> > 2) run pg_upgrade --link on both servers
> > 3) change ports so 9.2 is on 5432, 9.1 on 5433
> > 4) restart
> >
> > Is this the best way to do it and ensure that the WAL is still being created
> > and the master/slave relationship properly maintained?
>
> The problem is that after pg_upgrade the system catalog on the servers
> wont match. Therefore you need to rebuild your slave from scratch.
>
> There were some ideas around rsync [1], however, nobody proved that
> they work appropriately.
>
> [1] http://www.postgresql.org/message-id/20120320204916.GB26163@momjian.us
Yes, though there was discussion about this at PGCon 2013 and I plan to
work on this for 9.4.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2013-07-16 09:58 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-07-10 21:14 Upgrading from 9.1 to 9.2 - master AND slave Wells Oliver <wellsoliver@gmail.com>
2013-07-15 04:31 ` Sergey Konoplev <gray.ru@gmail.com>
2013-07-16 09:58 ` Bruce Momjian <bruce@momjian.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox