Re: Setting up replication from 9.4 to 10.4

2018-06-06 Thread Lionel Tressens
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 : > > > Am 06.0

Re: Setting up replication from 9.4 to 10.4

2018-06-05 Thread Andreas Kretschmer
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

Setting up replication from 9.4 to 10.4

2018-06-05 Thread 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 res