| From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Database health check/auditing |
| Date: | 2018-02-16 16:42:27 |
| Message-ID: | p671hl$rtn$1@blaine.gmane.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Azimuddin Mohammed | 2018-02-16 17:21:36 | Re: postgres started without auto vaccum |
| Previous Message | Ibrahim Edib Kokdemir | 2018-02-16 16:35:22 | Re: Database health check/auditing |