From: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | dba scripts & queries |
Date: | 2015-05-26 14:08:11 |
Message-ID: | CANu8Fixhg1em+3BJ9=RyWZhRtjdKT+bVZtZHJWsKRPi_W_8GMQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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*
Attachment | Content-Type | Size |
---|---|---|
dba_scripts.tar.gz | application/x-gzip | 10.8 KB |
queries.tqz | application/octet-stream | 14.2 KB |
queries.zip | application/zip | 30.8 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | William Dunn | 2015-05-26 14:31:59 | Re: Queries for unused/useless indexes |
Previous Message | Albe Laurenz | 2015-05-26 13:37:40 | Re: [tsvector] to_tsvector called multiple times |