Re: New Slave - timeline ERROR - Mailing list pgsql-general

From drum.lucas@gmail.com
Subject Re: New Slave - timeline ERROR
Date
Msg-id CAE_gQfWbCqn+EvTh5hYqFk3+XVix6RDphS5gOnx+DeDp2vkGqA@mail.gmail.com
Whole thread Raw
In response to Re: New Slave - timeline ERROR  (bricklen <bricklen@gmail.com>)
Responses Re: New Slave - timeline ERROR
List pgsql-general
Hi,

If you are able to stop Postgres on the slave you are taking the base backup from, you could do this:

I'm not... the data base is 2 TB.
So, a RSYNC would take DAYS.....  And I'm not able to stop the SLAVE for that long time

Lucas 



Lucas Possamai


On 10 January 2016 at 10:53, bricklen <bricklen@gmail.com> wrote:
On Sat, Jan 9, 2016 at 1:49 PM, drum.lucas@gmail.com <drum.lucas@gmail.com> wrote:
Hi,

If the master is successfully ships WALs to the slave you are setting up you do not need the "stream" option.

yes.. the master is successfully shipping the WALs....

Is there anything else? Help, please hehehehe

If you are able to stop Postgres on the slave you are taking the base backup from, you could do this:

1). Stop postgres on slave1
2). Rsync slave1 to slave2 to copy only the deltas.
3). When you start up slave2 the WALs that the master has shipped to slave2 should apply and bring your system up to consistency.

pgsql-general by date:

Previous
From: bricklen
Date:
Subject: Re: New Slave - timeline ERROR
Next
From: bricklen
Date:
Subject: Re: New Slave - timeline ERROR