what to do after a failover
Rita <[email protected]> Wed, 8 Jan 2020 23:06:28 -0500
| Newsgroups | gmane.comp.db.postgresql.general |
|---|---|
| Message-ID | <CAOF-KfiEitz3aTdJybdBvu_-y6oirt4YMmdfLjWGpcWG7+Ed=g@mail.gmail.com> |
--000000000000cacdf0059bad26b6 Content-Type: text/plain; charset="UTF-8" I run a master and standby setup with Postgresql 11. The systems are identical from a hardware and software setup. If the master goes down I can do a pg_ctl promote on the standby and point my applications to use the standby (new master). Once the original master is online, when is an appropriate time to fail back over? And are there any other things besides promote after the failover is done? -- --- Get your facts first, then you can distort them as you please.-- --000000000000cacdf0059bad26b6 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr">I run a master and standby setup with Postgresql 11. The s= ystems are identical from a hardware and software setup.=C2=A0 If the maste= r goes down I can do a pg_ctl promote on the standby and point my applicati= ons to use the standby (new master).=C2=A0<div><br></div><div>Once the orig= inal master is online, when is an appropriate time to fail back over? And a= re there any other things besides promote after the failover is done?</div>= <div><br></div><div><br>-- <br><div dir=3D"ltr" class=3D"gmail_signature" d= ata-smartmail=3D"gmail_signature">--- <span>Get your facts first, then you = can distort them as you please.</span>--</div></div></div> --000000000000cacdf0059bad26b6--