Re: Pg_basebackup does not do aything

thomas simon <tsimon@xxxxxxxxxxx> · Thu, 26 Jun 2014 00:24:02 +0200



    Yes, it did the trick !

    Thanks Matheus

    
    Something I don't understand is how my 2nd slave will be synced to
    master, because master's archive command only sent WAL files to 1st
    slave. 

    Does I have to archive on both slaves ? (is it possible) ?

    And what I am supposed to use with parameter "restore_command" ?

    In this case, my new slave will not start if i dont start it just
    after the end of the pg_basebackup ?

    
    Le 25/06/2014 22:49, Matheus de
      Oliveira a écrit :

    
          On Wed, Jun 25, 2014 at 4:58 PM,
            thomas simon <tsimon@xxxxxxxxxxx>
            wrote:

            
              My command is  :  pg_basebackup -D
              /data/postgresql/9.3/main -P -v -h MASTER -U replicator -X
              s
          
          
        I'm betting you are just waiting for a
          "spread" checkpoint. If that is the case, you can issue a
          CHECKPOINT command on the master and see if your backup start
          running, or you you can use "--checkpoint=fast" option for
          pg_basebackup.

        
        -- 

          Matheus de Oliveira

          Analista de Banco de Dados

          Dextra Sistemas - MPS.Br nível F!

          www.dextra.com.br/postgres