From: | Lionel Tressens <lionel(at)loungeup(dot)com> |
---|---|
To: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Setting up replication from 9.4 to 10.4 |
Date: | 2018-06-06 12:16:22 |
Message-ID: | CAPtQa1kFEa=_zGvzeU0du8Sq7RonmHBGA3W2AP-yqs1A64Vgbg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)a-kretschmer(dot)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 <+33661340142>
Email lionel(at)loungeup(dot)com
Website www.loungeup.com
<https://www.facebook.com/LoungeUp/> <https://twitter.com/loungeup>
<https://www.linkedin.com/company/loungeup>
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2018-06-06 12:41:25 | Using distinct in an aggregate prevents parallel execution? |
Previous Message | Łukasz Jarych | 2018-06-06 08:49:54 | Re: VBA to connect to postgresql from MS Access |