> > rsync -azr --progress --partial postgres@$MASTER_IP: > /var/lib/postgresql/data/var/lib/postgresql/data/ --exclude > postmaster.pid
Ah ok! So this will do an incrementa, right? not supposed to copy ALL the base/ again? Lucas Possamai kinghost.co.nz <http://forum.kinghost.co.nz/memberlist.php?mode=viewprofile&u=2&sid=e999f8370385657a65d41d5ff60b0b38> On 10 January 2016 at 11:31, bricklen <brick...@gmail.com> wrote: > > > On Sat, Jan 9, 2016 at 2:22 PM, drum.lu...@gmail.com <drum.lu...@gmail.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@$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. > >