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

From Thomas Kellerer
Subject Re: Database health check/auditing
Date
Msg-id p671hl$rtn$1@blaine.gmane.org
Whole thread Raw
In response to Database health check/auditing  (Tim Cross <theophilusx@gmail.com>)
Responses Re: Database health check/auditing  (Tim Cross <theophilusx@gmail.com>)
List pgsql-general
> 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.

You might want to have a look at OPM: http://opm.io/



pgsql-general by date:

Previous
From: Ibrahim Edib Kokdemir
Date:
Subject: Re: Database health check/auditing
Next
From: Azimuddin Mohammed
Date:
Subject: Re: postgres started without auto vaccum