El 26/12/17 a las 14:46, Edson Carlos Ericksson Richter escribió: > > Usually, or by "pg_basebackup" or by "rsync" as described in PostgreSQL > Wiki. > Right now, I'm doing via pg_basebackup. > Nothing extraordinary. > > When using rsync: > > rsync -e "ssh -2 -C -p slave_ssh_port" --progress --partial -az > /pgsql/9.6/master_data_folder/* > superuser_name@$slave_host:/home/pgsql/9.6/slave_data_folder/ --exclude > postmaster.pid --exclude postgresql.conf --exclude pg_log
You don't say so anywhere, but I suspect you run the rsync between a pg_start_backup() and pg_stop_backup(), right? That is the way it's described in the wiki. Regards, -- Martín Marqués http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
