Re: Database health check/auditing

On Fri, Feb 16, 2018 at 2:40 PM, Basques, Bob (CI-StPaul) <
bob(dot)basques(at)ci(dot)stpaul(dot)mn(dot)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(at)gmail(dot)com>
> wrote:
>
> Hi Tim,
> There are good continuously running apps to monitor postgres.
> IMHO, the most successful one is pgcenter.
> Here is the link. https://github.com/lesovsky/pgcenter
>
> Regards
> İbrahim
>
> On 16 Feb 2018 5:22 am, "Tim Cross" <theophilusx(at)gmail(dot)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/
<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.