Re: Streaming Replication Without Downtime

Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> · Fri, 17 Feb 2017 15:20:14 +0200



    Gabriel
        you are thinking this in the correct way, but its really :

        
        pg_basebackup -D <your data dir> --write-recovery-conf
        --progress --xlog-method=stream -h <your primary db
        server>

        then you just edit recovery.conf (if needed), tweak
        postgersql.conf (if needed) and start the standby .

      
      On 17/02/2017 15:09, Gunnar "Nick" Bluth wrote:

    
    (sorry for the toppost, mobile device) 

      What you're looking for is pg_basebackup with - - xlog=stream, I
      guess. 

      
      Regards, 

      
      Nick

      
      Am 17. Februar 2017 14:06:36 MEZ schrieb
        Gabriel Ortiz Lour <ortiz.admin@xxxxxxxxx>:
        
          Hi all,
              I've been searching for a way to initialize a new Hot
              Standby node with Streaming Replication withou the need
              for stop or even restarting the master.
              Of course the master is already with the needed SR
              configs.
            

              I know I have to use pg_start_backup/pg_stop_backup,
              but i'd like some tips, or a link to some tutorial, with
              the order of the steps.
            

              I assume will be something like:
            

            -  configure Slave for SR
            -  pg_start_backup()

            
            -  rsync PGDATA to slave

            
            -  start PG on the slave

            
            -  pg_stop_backup()

            
              Anything i'm thinking wrong?
            

            Thanks in advance,
            Gabriel
          
        
      -- 

      Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail
      gesendet.
    
    
    -- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt