From: | thomas simon <tsimon(at)neteven(dot)com> |
---|---|
To: | Matheus de Oliveira <matioli(dot)matheus(at)gmail(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Pg_basebackup does not do aything |
Date: | 2014-06-25 22:24:02 |
Message-ID: | 53AB4C02.1030907@neteven.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)neteven(dot)com
> <mailto:tsimon(at)neteven(dot)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 <http://www.dextra.com.br/postgres/>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Matheus de Oliveira | 2014-06-26 15:38:33 | Re: Pg_basebackup does not do aything |
Previous Message | Matheus de Oliveira | 2014-06-25 20:49:03 | Re: Pg_basebackup does not do aything |