Re: Database health check/auditing - Mailing list pgsql-general

From Melvin Davidson
Subject Re: Database health check/auditing
Date
Msg-id CANu8FiyS5EVdCPvgKwubMqsunz5F6YrvytvgOoHeXdhcuPYBoA@mail.gmail.com
Whole thread Raw
In response to Re: Database health check/auditing  ("Basques, Bob (CI-StPaul)" <bob.basques@ci.stpaul.mn.us>)
List pgsql-general


On Fri, Feb 16, 2018 at 2:40 PM, Basques, Bob (CI-StPaul) <bob.basques@ci.stpaul.mn.us> wrote:
All,

Not really an app, but we have a Apache script that logs all the activity to our Postgres/PostGIS services and inserts the log entries directly into Postgres.  Works great for reporting our Postgres web traffic stuff.  My dev guy was skeptical about it being effective and not binding up at some point, but it’s been running for a couple of years now with no ill effects.

I have a bunch of canned and automated reports being generated from it. 

bobb



On Feb 16, 2018, at 10:35 AM, Ibrahim Edib Kokdemir <kokdemir@gmail.com> wrote:

Hi Tim,
There are good continuously running apps to monitor postgres.
IMHO, the most successful one is pgcenter.

Regards 
İbrahim 

On 16 Feb 2018 5:22 am, "Tim Cross" <theophilusx@gmail.com> wrote:
Hi All,

I was wondering if anyone has some pointers to
sites/repositories/resources for scripts to perform basic database
audits and health checks.

situation: I have just commenced a DBA and developer role for an
organisation with a number of Postgres databases (9.4 and 9.6
versions). There has been no dedicated DBA and a number of the databases
were setup by people with little to know Postgres or database
experience. I need to get an overview on what I'm dealing with and start
prioritising what to address first.

It has been some years since I've done any real work with Postgres. Most
of my technical work over the last 10 years has been with Oracle. I
prefer to use scripts over GUI tools like pgAdmin and suspect that there
is probably some good resources out there with existing scripts I can
use as a starting point.

Any pointers greatly appreciated.

thanks,

Tim


--
Tim Cross



"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.
- Albert Einstein





> resources for scripts to perform basic database audits and health checks.

PgBadger is free and an excellent log analyzer which is useful for tracking query  execution times and transaction rates.

https://sourceforge.net/projects/pgbadger/

--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

pgsql-general by date:

Previous
From: chris
Date:
Subject: gathering ownership and grant permissions
Next
From: Tim Cross
Date:
Subject: Re: Database health check/auditing