Re: Pg_basebackup does not do aything - Mailing list pgsql-admin

From thomas simon
Subject Re: Pg_basebackup does not do aything
Date
Msg-id 53AB4C02.1030907@neteven.com
Whole thread Raw
In response to Re: Pg_basebackup does not do aything  (Matheus de Oliveira <matioli.matheus@gmail.com>)
Responses Re: Pg_basebackup does not do aything
List pgsql-admin
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@neteven.com> 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


pgsql-admin by date:

Previous
From: Matheus de Oliveira
Date:
Subject: Re: Pg_basebackup does not do aything
Next
From: Matheus de Oliveira
Date:
Subject: Re: Pg_basebackup does not do aything