pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
upgrade slave in streaming replication from PG 10.4 to 10.5.1 2+ messages / 2 participants [nested] [flat]
* upgrade slave in streaming replication from PG 10.4 to 10.5.1 @ 2018-10-25 14:53 Ghiurea, Isabella <Isabella.Ghiurea@nrc-cnrc.gc.ca> 2018-10-25 18:07 ` Re: upgrade slave in streaming replication from PG 10.4 to 10.5.1 Johannes Truschnigg <johannes@truschnigg.info> 0 siblings, 1 reply; 2+ messages in thread From: Ghiurea, Isabella @ 2018-10-25 14:53 UTC (permalink / raw) To: pgsql-admin Gmorning List, we have a system running PG streaming replication using repmgr4 , PG hosts are running Cent OS 7 with PG 10.4, we have a request to upgrade to PG 10.5 , my plan is to upgrade the slave db host first and later on /next month switch over and upgrade the existing PG master, we are using the following PG extensions: citext , pg_sphere,pg_stat_statements,pgrowlocks. Also in existing PG 10.4 cfg:/data/ pg_wal is a link and we have cfg multiple tablespaces Are any issues related to replication if we are upgrading the PG slave host first , ? Thank you Isabella ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: upgrade slave in streaming replication from PG 10.4 to 10.5.1 2018-10-25 14:53 upgrade slave in streaming replication from PG 10.4 to 10.5.1 Ghiurea, Isabella <Isabella.Ghiurea@nrc-cnrc.gc.ca> @ 2018-10-25 18:07 ` Johannes Truschnigg <johannes@truschnigg.info> 0 siblings, 0 replies; 2+ messages in thread From: Johannes Truschnigg @ 2018-10-25 18:07 UTC (permalink / raw) To: Ghiurea, Isabella <Isabella.Ghiurea@nrc-cnrc.gc.ca>; +Cc: pgsql-admin Hi Isabella, On Thu, Oct 25, 2018 at 02:53:35PM +0000, Ghiurea, Isabella wrote: > Gmorning List, > > we have a system running PG streaming replication using repmgr4 , PG hosts > are running Cent OS 7 with PG 10.4, we have a request to upgrade to PG 10.5 > , my plan is to upgrade the slave db host first and later on /next month > switch over and upgrade the existing PG master, we are using the following > PG extensions: citext , pg_sphere,pg_stat_statements,pgrowlocks. Your question reads to me as if you somehow missed the important change in pg's version numbering scheme that 10.0 introduced: These days, 10.n to 10.n+1 is not considered a major release upgrade (of the sort that requires pg_upgrade or dump+restore, etc.) any more; it's what (e.g.) 9.6.n to 9.6.n+1 used to be. Therefore, both versions you mentioned should be compatible and allow physical replication between themselves, no matter if the master or the slave are on the newer (minor) version than the other. > Also in existing PG 10.4 cfg:/data/ pg_wal is a link and we have cfg > multiple tablespaces Shouldn't matter, if your existing configuration works. Just install the new, upgraded binaries, restart your service(s), and you should be good to go. Personally, I'd upgrade the slave first- if anything goes awry (very unlikely, but accidents happen!), you don't have to fail over that way. > Are any issues related to replication if we are upgrading the PG slave host first , ? Not in this scenario - if you were doing an actual major release upgrade (10.x to 11.x or later), you'd have to get more creative and (probably - there are options, if you cannot afford that kind of interruption, but they are a bit more involved) break replication for a while. If it comes to that, I'm sure someone the list will be able to help out. Cheers, and best of luck with your upgrade procedure! -- with best regards: - Johannes Truschnigg ( johannes@truschnigg.info ) www: https://johannes.truschnigg.info/ phone: +43 650 2 133337 xmpp: johannes@truschnigg.info Please do not bother me with HTML-email or attachments. Thank you. Attachments: signature.asc (application/pgp-signature, 832B) download ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-10-25 18:07 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2018-10-25 14:53 upgrade slave in streaming replication from PG 10.4 to 10.5.1 Ghiurea, Isabella <Isabella.Ghiurea@nrc-cnrc.gc.ca> 2018-10-25 18:07 ` Johannes Truschnigg <johannes@truschnigg.info>
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