Database health check/auditing

From: Tim Cross <theophilusx(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Database health check/auditing
Date: 2018-02-16 02:22:28
Message-ID: CAC=50j8LdT3W_f_aZ+nVnER-Ok0Yh_ZX2NgLGJ4P3WrcbY1Bow@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2018-02-16 03:11:38 Re: Database health check/auditing
Previous Message Alan Hodgson 2018-02-16 00:54:20 Re: postgres not starting