Re: Pg_basebackup does not do aything

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 ?

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