| From: | Lionel Tressens <lionel(at)loungeup(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Setting up replication from 9.4 to 10.4 |
| Date: | 2018-06-06 06:16:17 |
| Message-ID: | CAPtQa1=Roacrq-V9NvPsfShWbW_zihE2p12xPNxSp-GMFozg+w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Kretschmer | 2018-06-06 06:40:19 | Re: Setting up replication from 9.4 to 10.4 |
| Previous Message | Chris Travers | 2018-06-06 05:27:40 | Re: Code of Conduct plan |