Re: Postgres switchover and switchback

Ron <ronljohnsonjr@xxxxxxxxx> · Fri, 20 May 2022 00:05:13 -0500



    On 5/18/22 09:23, David Jordan wrote:

    
          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.