On Wed, Nov 6, 2013 at 9:40 AM, Jeff Ross <jross@wykids.org> wrote:
_postgresql@nirvana:/var/postgresql $ cat start_hot_standby.sh #!/bin/sh backup_label=wykids_`date +%Y-%m-%d` #remove any existing wal files on the standby ssh dukkha.internal rm -rf /wal/* #stop the standby server if it is running ssh dukkha.internal sudo /usr/local/bin/svc -d /service/postgresql.5432 psql -c "select pg_start_backup('$backup_label');" template1 rsync \ --copy-links \ --delete \ --exclude=backup_label \
Excluding backup_label is exactly the wrong thing to do. The only reason backup_label is created in the first place is so that it can be copied to the replica, where it is needed. It's existence on the master is a nuisance.