From: | John McKown <john(dot)archie(dot)mckown(at)gmail(dot)com> |
---|---|
To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: dba scripts & queries |
Date: | 2015-05-26 15:02:44 |
Message-ID: | CAAJSdjjjpseVsSbBC9ZcvKCVhR+JzBMexGBhSgKMEJwC-5bPWQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
With Melvin's kind permission, I have created a repository on github which
has all of these files in it. Hopefully that will allow them to "stick
around" a bit longer. You can peruse them at:
https://github.com/JohnArchieMckown/PostgreSQL-DBA-tools
Also, this allows you to preview individual files and, if you want, to only
get those which you want right now. I will also add, as Melvin has in his
README, that these are "as is" and there is __NO__ support for them. If
they work, you're golden. If the don't, ... .
On Tue, May 26, 2015 at 9:08 AM, Melvin Davidson <melvin6925(at)gmail(dot)com>
wrote:
>
> Based on several positive feedback's from my previous submission for
> unused index queries, I've decided to contribute most all of the scripts
> and queries I've written or collected over my career. Therefore please find
> attached:
>
> dba_scripts.tar.gz -> scripts to automate specific queries. Note that
> there are two potentially dangerous scripts.
>
> flip_database_connect.sh -> Changes the state of datallowconn for a
> specific database
> logins_block.sh -> prevents all non-superusers from future logins. MUST be
> run as user postgres
>
> queries.tgz -> sql only queries (but more than dba_scripts)
> queries.zip -> Same as above, but for Windows O/S, even though I do not
> advise running production on Windows.
>
> Please remember to read the README.txt provided with each for a general
> explanation.
>
> If for some reason the attachments did not work, you can email me directly
> and I will send to your email.
>
> CAVEAT EMPTOR!
> Please DO NOT write to me asking me why I did things one way when you
> think it should be done another way, or way I chose specific values for a
> query. There are several available editors you can use to make your own
> changes.
> IOW: Do not peer into the oral cavity of an equestrian present!
>
>
> --
> *Melvin Davidson*
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>
--
My sister opened a computer store in Hawaii. She sells C shells down by the
seashore.
If someone tell you that nothing is impossible:
Ask him to dribble a football.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
From | Date | Subject | |
---|---|---|---|
Next Message | William Dunn | 2015-05-26 15:32:57 | Re: Queries for unused/useless indexes |
Previous Message | William Dunn | 2015-05-26 14:31:59 | Re: Queries for unused/useless indexes |