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
Tim, Good luck to you. I have been in your situation a few times. I have attached the following scripts which I use as a starter to get a general idea of database status. All of the should run on both 9.4 & 9.4, but sometimes catalog changes may fudge things up, so you may have to tweak a bit. I have many more general queries, so if you have any specific need, let me know and I'll be glad to send if I have one that fits the need.
The names should be self descriptive as to what the do but except for get_trans_min_cnt.sql (Transaction per minute) none have any DDL.