Hi Sam,
Thank your sharing this script.
> Here's a script to make your backup and rsync it to a remote destination:
> #!/bin/bash
> echo "checkpoint"
> echo "CHECKPOINT;" | /local/pkg/bin/psql template1
> echo "start backup"
> echo "SELECT pg_start_backup('cisoradr:/cis/pgsql/katana7/backup');" |
/local/pkg/bin/psql template1
> echo "rsync"
> /local/pkg/bin/rsync --delete -azxH /local/app/postgres/data
pgsql@cisoradr-ext:/cis/pgsql/katana7/backup/.
> echo "Stop backup"
> echo "SELECT pg_stop_backup();" | /local/pkg/bin/psql template1
