Hi, We have created a postgres database with a warm-standby in postgres 8.2 following the document on the archive by Charles Duffy. The standby database is in continuous recovery mode and archived logs are synced to the standby from primary, every 10 minutes. The primary and the standby database are running fine but we need to monitor the standby database to check that it is up, it is getting synced every 10 minutes, and that it is not out of sync with primary database. What would be the best way to make these checks or what processes to check to make sure that the archived logs from primary database are continuously getting applied on the standby database. There must be other people using this set up so just need advice on how people are monitoring the standby database. Any suggestions or help will be highly appreciated. Thanks Paramjeet Bhella
