Search Postgresql Archives

Re: New Slave - timeline ERROR

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

 



rsync would be something like:

from slave1:
rsync -av data/pg_xlog slave2:/var/lib/postgresql/data/

Is that correct?

At this point I think your options are slim. If you are feeling adventurous, you can try doing the rsync with the slave running, then do a second rsync with the slave stopped or do it from the master after putting the master in backup mode (eg. executing "pg_start_backup('slave_backup')")

I didn't unterstand why doing RSYNC twice... sorry

Lucas



Lucas Possamai


On 10 January 2016 at 11:19, bricklen <bricklen@xxxxxxxxx> wrote:
On Sat, Jan 9, 2016 at 2:10 PM, drum.lucas@xxxxxxxxx <drum.lucas@xxxxxxxxx> wrote:
I could stop the slave then.... But I'm afraid getting it back online and get some other errors

At this point I think your options are slim. If you are feeling adventurous, you can try doing the rsync with the slave running, then do a second rsync with the slave stopped or do it from the master after putting the master in backup mode (eg. executing "pg_start_backup('slave_backup')")



[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