Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres switchover and switchback - Mailing list pgsql-admin

From Ron
Subject Re: Postgres switchover and switchback
Date
Msg-id 46af6991-03bf-3843-2640-46a297c9c409@gmail.com
Whole thread Raw
In response to Postgres switchover and switchback  (David Jordan <itman73@protonmail.com>)
List pgsql-admin
Tree view
On 5/18/22 09:23, David Jordan wrote:
@font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; font-size:11.0pt; font-family:"Calibri",sans-serif;}span.EmailStyle19 {mso-style-type:personal-compose; font-family:"Times New Roman",serif;}.MsoChpDefault {mso-style-type:export-only; font-size:10.0pt;}div.WordSection1 {page:WordSection1;}

Hi, folks;

 

I’m a former Oracle database administrator of many years who is new to PostgreSQL.  I’m in the process of testing PG v12.7 hot streaming standby’s in async mode, and specifically in the areas of switchover and switchback. 


Async mode, huh?


In SQL Server, at least, you must be in synchronous replication mode before doing a (manual or automatic) non-crash failover, to guarantee that all the transaction log data has reached the replica before the switchover.


--
Angular momentum makes the world go 'round.

pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: bash or sql script to copy foreign table to locale table
Next
From: Laurenz Albe
Date:
Subject: Re: Locks under the hood on re-mat and dropping triggers