Re: Database health check/auditing

2018-02-16 Thread Tom Lane
George Neuner writes: > On Sat, 17 Feb 2018 07:23:32 +1100, Tim Cross > wrote: >> Thomas Kellerer writes: >>> Plus: trimming the original content, so that not the whole email >>> thread is repeated in the quote. >> While I'm happy to comply, I disagree with trimming/editing the >> thread. > Th

List policy/procedures [was Database health check/auditing]

2018-02-16 Thread Tim Cross
George Neuner writes: > On Sat, 17 Feb 2018 07:23:32 +1100, Tim Cross > wrote: > >>Thomas Kellerer writes: >> >>> Plus: trimming the original content, so that not the whole email >>> thread is repeated in the quote. >> >>While I'm happy to comply, I disagree with trimming/editing the >>thread.

Re: Database health check/auditing

2018-02-16 Thread George Neuner
On Sat, 17 Feb 2018 07:23:32 +1100, Tim Cross wrote: >Thomas Kellerer writes: > >> Plus: trimming the original content, so that not the whole email >> thread is repeated in the quote. > >While I'm happy to comply, I disagree with trimming/editing the >thread. Certainly made sense when networks w

Re: Database health check/auditing

2018-02-16 Thread Basques, Bob (CI-StPaul)
What Tim said!! :c) I think the bigger deal is setting a new message Subject at the approriate point in a thread/conversation. bobb On Feb 16, 2018, at 2:23 PM, Tim Cross mailto:theophil...@gmail.com>> wrote: Thomas Kellerer mailto:spam_ea...@gmx.net>> writes: Melvin Davidson schrieb am

Re: Database health check/auditing

2018-02-16 Thread Tim Cross
Thomas Kellerer writes: > Melvin Davidson schrieb am 16.02.2018 um 05:26: >> Tim, >> >> FYI, the policy in this list is to avoid top posting and bottom post instead. > > Plus: trimming the original content, so that not the whole email thread is > repeated in the quote. > > Thomas While I'm ha

Re: Database health check/auditing

2018-02-16 Thread Tim Cross
Melvin Davidson writes: > On Fri, Feb 16, 2018 at 10:46 AM, Basques, Bob (CI-StPaul) < > bob.basq...@ci.stpaul.mn.us> wrote: > >> >> What about bottom *and* top posting. Just joking sort of. I really like >> to reply to questions inline myself on a lot of occasions. >> >> Seems like a good Mai

Re: Database health check/auditing

2018-02-16 Thread Tim Cross
Thomas Kellerer writes: >> 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 databas

Re: Database health check/auditing

2018-02-16 Thread Tim Cross
Ibrahim Edib Kokdemir writes: > 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 > Thanks, a useful link. Tim -- Tim Cross

Re: Database health check/auditing

2018-02-16 Thread Melvin Davidson
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 o

Re: Database health check/auditing

2018-02-16 Thread Basques, Bob (CI-StPaul)
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

Re: Database health check/auditing

2018-02-16 Thread Thomas Kellerer
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 overvie

Re: Database health check/auditing

2018-02-16 Thread Ibrahim Edib Kokdemir
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" wrote: > Hi All, > > I was wondering if anyone has some pointers to > site

Re: Database health check/auditing

2018-02-16 Thread Melvin Davidson
On Fri, Feb 16, 2018 at 10:46 AM, Basques, Bob (CI-StPaul) < bob.basq...@ci.stpaul.mn.us> wrote: > Melvin, > > Thanks for posting these. I haven’t even looked at them yet and just > grabbed them based on the names. :c) > > > On Feb 15, 2018, at 9:11 PM, Melvin Davidson wrote: > > > > On Thu, Fe

Re: Database health check/auditing

2018-02-16 Thread Basques, Bob (CI-StPaul)
Melvin, Thanks for posting these. I haven’t even looked at them yet and just grabbed them based on the names. :c) On Feb 15, 2018, at 9:11 PM, Melvin Davidson mailto:melvin6...@gmail.com>> wrote: On Thu, Feb 15, 2018 at 9:22 PM, Tim Cross mailto:theophil...@gmail.com>> wrote: Hi All, I

Re: Database health check/auditing

2018-02-15 Thread Thomas Kellerer
Melvin Davidson schrieb am 16.02.2018 um 05:26: > Tim, > > FYI, the policy in this list is to avoid top posting and bottom post instead. Plus: trimming the original content, so that not the whole email thread is repeated in the quote. Thomas

Re: Database health check/auditing

2018-02-15 Thread Melvin Davidson
On Thu, Feb 15, 2018 at 11:03 PM, Tim Cross wrote: > Hi Mel, > > thanks a lot. The databases are all running on Red Hat (well OUL to be > specific). The SQL is fine and I can always wrap them in a bash script if > needed. > > Having these scripts is a real help. My biggest challenge at the moment

Re: Database health check/auditing

2018-02-15 Thread Tim Cross
Hi Mel, thanks a lot. The databases are all running on Red Hat (well OUL to be specific). The SQL is fine and I can always wrap them in a bash script if needed. Having these scripts is a real help. My biggest challenge at the moment is just turning off my Oracle habits and getting back Postgres o

Re: Database health check/auditing

2018-02-15 Thread Melvin Davidson
On Thu, Feb 15, 2018 at 9:22 PM, Tim Cross 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

Database health check/auditing

2018-02-15 Thread Tim Cross
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 b