Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes?

David Guyot <david.guyot@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> · Tue, 02 Apr 2013 16:53:12 +0200



    Mister,

    
    Thank you for your answer. I had in mind that this line was for the
    initial start of the standby; should I just comment it before
    promoting the standby, or is this line useless for the day-to-day
    standby service?

    
    Thank you in advance.

    
    Regards.

    
    Le 02/04/2013 16:47, Douglas J Hunley a
      écrit :

    
          On Tue, Apr 2, 2013 at 10:29 AM,
            David Guyot (English) <david.guyot@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
            wrote:

            
              restore_command = 'rsync -av
                192.168.0.80:/var/lib/postgresql/WAL/%f %p'
            
          
          You're telling the recovery process to get the files off the
          (now dead) master here...

          
          -- 

          Douglas J Hunley (doug.hunley@xxxxxxxxx)

          Twitter: @hunleyd                                            
            Web: douglasjhunley.com

          G+: http://goo.gl/sajR3
        
      
    -- 
David Guyot
Administrateur système, réseau et télécommunications
Europe Camions Interactive
Moulin Collot
F-88500 Ambacourt

Tel: +33 (0)3 29 30 47 85
Fax : +33 (0)3 29 31 31 31
  

Attachment:
signature.asc

Description: OpenPGP digital signature