On Fri, Feb 16, 2018 at 2:40 PM, Basques, Bob (CI-StPaul) < bob.basq...@ci.stpaul.mn.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 <kokde...@gmail.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" <theophil...@gmail.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.
