Postgres Pro
Downloads
Home   >   mailing lists

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

From drum.lucas@gmail.com
Subject Re: New Slave - timeline ERROR
Date
Msg-id CAE_gQfUsYABMO7=SAJ5mcXp4z8wjvOXn_Q=uKd00erO1U_qtAQ@mail.gmail.com
Whole thread Raw
In response to Re: New Slave - timeline ERROR  (bricklen <bricklen@gmail.com>)
Responses Re: New Slave - timeline ERROR  (bricklen <bricklen@gmail.com>)
List pgsql-general
Tree view
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@gmail.com> wrote:
On Sat, Jan 9, 2016 at 2:10 PM, drum.lucas@gmail.com <drum.lucas@gmail.com> 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')")


pgsql-general by date:

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