Re: Streaming Replication - changing IP addresses

John R Pierce <pierce@xxxxxxxxxxxx> · Mon, 08 Dec 2014 12:11:31 -0800



    On 12/8/2014 11:56 AM, Dara Unglaube
      wrote:

    
    We have streaming replication set up on two servers
      that are
      on our local network using their
      external/public IP addresses. We are switching
      internet providers and need to change the external/public IP
      addresses of both
      servers. I'm not sure how to go about this correctly.

      
        Our local network IP
          addresses will not be changing, is there any reason we
          could/should
          not use our local network IP addresses in the streaming
          replication
          process? 

        
        What is the best route to make these changes? Is it as
          simple as turning postgres off on both servers, changing the
          IP settings
          (master - postgres.conf and hba.conf and slave - recovery.conf
          files
          to the local network IPs) and starting the service up again?
          Can anyone point me to an example?

        
      Any tips,
        suggestions, help you could provide would be greatly
        appreciated.
      Thanks in advance
        for your time!
    
    
    if these two servers are both local, there's absolutely no reason to
    use public IP space for this, they should be using their local
    addresses, faster, lower latency, otherwise each round trip packet
    is going through 4 layers of NAT (out, in, then out, in again to
    return).

    
    make sure the master allows the slave replication account to connect
    via its local IP (this would be in pg_hba.conf, and  a 'reload'),
    then change the address the slave is using to connect to the master,
    and restart the slave, and it all should be good.  

    
    -- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast