| From: | bricklen <bricklen(at)gmail(dot)com> |
|---|---|
| To: | "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: New Slave - timeline ERROR |
| Date: | 2016-01-09 22:31:50 |
| Message-ID: | CAGrpgQ9BharvX-RuaU4Qy2buW7Qn1gpRb6QA3BA5d_W_M5G8aQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, Jan 9, 2016 at 2:22 PM, drum(dot)lucas(at)gmail(dot)com <drum(dot)lucas(at)gmail(dot)com>
wrote:
> *rsync would be something like:*
>
> from slave1:
> rsync -av data/pg_xlog slave2:/var/lib/postgresql/data/
>
Normally I run something like the following from the slave I am setting up.
rsync -azr --progress --partial postgres(at)$MASTER_IP:/var/lib/postgresql/data
/var/lib/postgresql/data/ --exclude postmaster.pid
> I didn't unterstand why doing RSYNC twice... sorry
>
Unless the source db cluster you are rsync'ing from is stopped, there will
be changes to data files replicated from the master. The second rsync might
not be necessary given the WALs are shipping from the master to slave2.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | drum.lucas@gmail.com | 2016-01-09 22:35:25 | Re: New Slave - timeline ERROR |
| Previous Message | drum.lucas@gmail.com | 2016-01-09 22:22:22 | Re: New Slave - timeline ERROR |