Search Postgresql Archives

Re: Setting up replication from 9.4 to 10.4

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thanks Andreas,

pglogical seems really great.
My knowledge of replication was frozen at the time of Slony II and PG 8.4, I didn't have the chance to use replication since that time.
I'll give a look at pglogical !

Best regards

Lionel

2018-06-06 8:40 GMT+02:00 Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx>:


Am 06.06.2018 um 08:16 schrieb Lionel Tressens:
Hello,

We are running a single PG 9.4 database node we are switching to PG 10.4 (which will run as master + setup of a slave)

To minimize downtime when switching from the 9.4 server to the 10.4 one, I would like to setup a replication stream instead of stopping the production, dumping 9.4 and restoring in 10.4 which my take a lot of time.

The next steps would be to reinstall the 9.4 server from scratch with 10.4 and setup this host as a slave, ready to take the master role if needed (hot standby).

Can such a replication be established between 9.4 and 10.4 and what replication tool/schema to use ? I have been through the documentation on replication in 9.4 and 10.4 but things are very confusing to me about this point.


you can't use the in-build streaming replication between different major versions, but you can use trigger-based replications, for instance londiste or slony.

You can also use use our extension pglogical, see https://www.2ndquadrant.com/en/resources/pglogical/. If i were you i would use the latter ;-)


Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com





--
Lionel TRESSENS
Co-founder & CTO - LoungeUp

Mobile +33 6 61 34 01 42
  

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux