Should I point of replication new slave to same DB? Lucas
On Sunday, 10 January 2016, bricklen <brick...@gmail.com> wrote: > On Sat, Jan 9, 2016 at 2:35 PM, drum.lu...@gmail.com > <javascript:_e(%7B%7D,'cvml','drum.lu...@gmail.com');> < > drum.lu...@gmail.com > <javascript:_e(%7B%7D,'cvml','drum.lu...@gmail.com');>> wrote: > >> 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? >> > > Yes, this is for incremental copying from the upstream source. > Actually, you don't need the -r with -a (it is implied), and you can run > it first with --dry-run to see what it _would_ do. > If you are not shipping over the WAN, then omit the -z flag as you do not > need compression. > -- Lucas Possamai kinghost.co.nz <http://forum.kinghost.co.nz/memberlist.php?mode=viewprofile&u=2&sid=e999f8370385657a65d41d5ff60b0b38>