Search Postgresql Archives

Re: New Slave - timeline ERROR

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> wrote:
On Sat, Jan 9, 2016 at 1:49 PM, drum.lucas@xxxxxxxxx <drum.lucas@xxxxxxxxx> 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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux