Postgres Pro
Downloads
Home   >   mailing lists

Thread: Setting up replication from 9.4 to 10.4

Setting up replication from 9.4 to 10.4

From
Lionel Tressens
Date:
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.

Thanks for your tips

Lionel

Re: Setting up replication from 9.4 to 10.4

From
Andreas Kretschmer
Date:

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

Re: Setting up replication from 9.4 to 10.4

From
Lionel Tressens
Date:
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@a-kretschmer.de>:


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