Re: Pausing log shipping for streaming replication

archive_command:

archive_command = '/usr/local/pgsql/data/log_shipper.sh "%p" "%f"'

log_shipper.sh

#!/usr/local/bin/bash

rsync -a $1 pgprod@prod-db-slave:archive/$2 < /dev/null;

rsync -a $1 pgprod@prod-db-slave:p3_wal_files/$2 < /dev/null; # Temp storage for WAL files

recovery.conf

standby_mode = 'on'

primary_conninfo = 'host=prod-db port=5434 user=USER password=PW'

trigger_file = '/tmp/pgsql_prod_db.trigger'

restore_command = 'cp -f /usr/local/pgsql/archive/%f %p < /dev/null'

archive_cleanup_command = 'pg_archivecleanup /usr/local/pgsql/archive/ %r'