Skip site navigation (1) Skip section navigation (2)

Desperately need a magical PG monitoring tool

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Desperately need a magical PG monitoring tool
Date: 2012-03-26 18:58:47
Message-ID: (view raw or whole thread)
Lists: pgsql-general

is there a tool for monitoring PG servers?

Something that checks if a master and a hot-standby is still running 

I'd be nice if one could generously overlook some errors like wrong 

The standby should be watched if it keeps in sync with the master.

I have a cron job that does regularly pg_dumps and compresses them by 7zip.
I'd like to check automatically if this backup got done and wether the 
archive is actually OK.
I'm not fixed on this combination. Any compressing backup solution would do.

Last week I had memory allocation errors in the db-server that 
eventually crashed PG after a couple of automatical restarts.

After a manual restart thursday PG at first seemed to run OK but later 
it prooved that at least one table got messed up so the nightly pg_dump 
failed. I found out on friday and ended up with the last intact backup 
from wednesday night.  :(
Until today I had no standby server so this wasn't really pleasant.

Is there a possibility to get ASAP informed when such a data corruption 

How do you watch that all runs well ?


pgsql-general by date

Next:From: YangyangDate: 2012-03-26 20:32:16
Subject: DBT-3 workload running error: tmp_query.sql is missing
Previous:From: Norberto DellĂȘDate: 2012-03-26 18:54:52
Subject: pgstat wait timeout

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group