Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Wzvbz-0005CZ-85 for pgsql-admin@arkaria.postgresql.org; Wed, 25 Jun 2014 22:24:15 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Wzvbx-0003Gr-2v for pgsql-admin@arkaria.postgresql.org; Wed, 25 Jun 2014 22:24:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Wzvbw-0003Gk-0R for pgsql-admin@postgresql.org; Wed, 25 Jun 2014 22:24:12 +0000 Received: from mail3.neteven.com ([37.59.178.241]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Wzvbr-0001ky-UA for pgsql-admin@postgresql.org; Wed, 25 Jun 2014 22:24:10 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by mail3.neteven.com (Postfix) with ESMTP id E9CFE2207E4; Thu, 26 Jun 2014 00:24:04 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at mail3.neteven.com Received: from mail3.neteven.com ([127.0.0.1]) by localhost (mail3.neteven.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id LkBvCNmM0Epi; Thu, 26 Jun 2014 00:24:04 +0200 (CEST) Received: from [192.168.0.30] (pon77-2-88-187-41-168.fbx.proxad.net [88.187.41.168]) (using TLSv1 with cipher ECDHE-RSA-AES128-SHA (128/128 bits)) (Client did not present a certificate) by mail3.neteven.com (Postfix) with ESMTPSA id 5CC9322061A; Thu, 26 Jun 2014 00:24:03 +0200 (CEST) Message-ID: <53AB4C02.1030907@neteven.com> Date: Thu, 26 Jun 2014 00:24:02 +0200 From: thomas simon User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.6.0 MIME-Version: 1.0 To: Matheus de Oliveira CC: "pgsql-admin@postgresql.org" Subject: Re: Pg_basebackup does not do aything References: <53AB29E8.6010209@neteven.com> In-Reply-To: Content-Type: multipart/alternative; boundary="------------030005050601000907070406" X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multi-part message in MIME format. --------------030005050601000907070406 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit 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 > 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 > --------------030005050601000907070406 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit 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


--------------030005050601000907070406--