Fixing Replication on Postgres
This morning I noticed that my replicated database wasn't synced to the master, and that meant that something had happened to cause the master to be moving too much data, or have too long a pause time to keep synced. Re-establishing the link isn't all that hard, but it takes time - so I turned off the process feeding data into the master database, and then, as the postgres user I coped the files from the master to the slave:
$ cd /var/groupon $ rsync -av --exclude postgresql.conf --exclude postmaster.pid pgsql/ db2:/var/groupon/pgsql/
and then I simply need to restart the properly configured slave, and restart, and the log will report:
LOG: streaming replication successfully connected to primary