The following documentation comment has been logged on the website:


Seems to need a persistent connection:

<quote> Making a non-exclusive low level backup
The connection calling pg_start_backup must be maintained until the end of
the backup, or the backup will be automatically aborted.

The sample works with a NON-persistent connection (psql -c):

<quote> Standalone Hot Backups
...      touch /var/lib/pgsql/backup_in_progress
psql -c "select pg_start_backup('hot_backup');"
tar -cf /var/lib/pgsql/backup.tar /var/lib/pgsql/data/
psql -c "select pg_stop_backup();"
rm /var/lib/pgsql/backup_in_progress
tar -rf /var/lib/pgsql/backup.tar /var/lib/pgsql/archive/

Reply via email to