Debian Squeeze LTS
Recently we switched from a backup solution around
hot_backups to using
This solution used a pid file as long as the hot_backup was running, once finished, it would remove the pidfile.
For (re)storing the Dump on another server we would use a script to check for the
pid, and transfer the Dumpfile if no PIDfile exists.
As the hot_backup was quite easy to spot in case something went wrong (f.e. more than 24h dumptime) Issues which arised were promptly figured out and fixed.
As we now use
pg_dumpall i am in the research of how to better determine if the dump is finished or still ongoing.
Currently we use the same PID approach as before.
However i would like to have a query/command/something to check if the dump is still running or not from within postgres.