pg_slave.sh

# slave 10.0.1.3
sudo /etc/init.d/postgresql stop
sudo bash -c "rm -r /var/lib/postgresql/9.1/main/pg_xlog/*"

# master 10.0.1.2
sudo su - postgres
psql -c ";SELECT pg_start_backup('backup', true)";
rsync -av --rsync-path "sudo rsync" --exclude postmaster.pid --exclude pg_xlog /var/lib/postgresql/9.1/main/ [email protected]:/var/lib/postgresql/9.1/main/
psql -c ";SELECT pg_stop_backup()";

# slave 10.0.1.3
sudo /etc/init.d/postgresql start