Postgres Pro
Downloads
Home   >   mailing lists

Thread: Dily health checks to be created in short time

Dily health checks to be created in short time

From
"Machiel Richards"
Date:

Good day all

 

                I am very new to postgress and have not had time to properly learn how the database works and fit together yet (even though I do have a manual, other clients are taking up too much of my time).

 

                I need to create a checklist and SOP document that needs to be sent out today for a daily health check process on all postgres databases.

 

                Can anyone assist on ideas on what to check and maybe resources where I can find out how to do this in order to incorporate this in the SOP.

 

                Your help will be greatly appreciated as I need to do this before end of business today.

 

Regards

Machiel

 

Re: Dily health checks to be created in short time

From
Joshua Tolley
Date:
On Mon, Feb 15, 2010 at 11:47:35AM +0200, Machiel Richards wrote:
>                    I need to create a checklist and SOP document that needs
>    to be sent out today for a daily health check process on all postgres
>    databases.

One thing lots of people use is check_postgres.pl [1]. It provides "actions"
to check all sorts of aspects of database health, in general without impacting
the database particularly. You might read through its documentation and find a
list of actions you feel would provide the monitoring you're looking for.

[1] http://bucardo.org/wiki/Check_postgres

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
Attachment