Re: Streaming replication failover process - Pgsql 9.2

John R Pierce <pierce@xxxxxxxxxxxx> · Sun, 10 Jul 2016 15:05:19 -0700



    On 7/10/2016 2:42 PM, Andreas
      Kretschmer wrote:

    
      1. When the
        connection comes back, will the master and slave work as
        expected? The streaming replication should be ok?
        

      if the master holds all needed WAL's there should be no problem.
      

      You can ensure that with wal_keep_segments, or, in newer version,
      via replication slots.
    
    
    or via an external WAL archive, that the master writes, and the
      slave has access to.

    
    -- 
john r pierce, recycling bits in santa cruz