Search Postgresql Archives

Detecting if the DB is in backup mode or not

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello,

 

I am running pg 8.3, and I’m working on some scripts to take online backups of the database with backup mode and netapp snapshots.  I can successfully run the pg_start_backup/pg_stop_backup functions, but how to I query to see what mode the DB currently is in?  If my script fails to run the stop_backup, I’d like to have some external monitoring that can alert me to the database being stuck in backup mode.

 

Thanks

-Adam

 

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux