POSTGRES DB SCRIPTS
Please write in comment section, if links are not working.
DATABASE MANAGEMENT
OBJECT MANAGEMENT
MAINTENANCE
USER MANAGEMENT
TABLESPACE MANAGEMENT
BACKUP & RECOVERY
AUDITING & SECURITY
NETWORK
REPLICATION
PERFORMANCE
GENERIC
GENERIC
-
- This page will be updated regularly with new scripts.Please provide suggestions to improve this page.
Keep visiting us.
Thank you very much ,
Scripts stopped opening
Dear, This has been fixed. Please let me know if you are still facing issue?
Regards
Admin
Unchanged. Mozilla Firefox without blocking scripts and clean Microsoft Edge – when you click on the link, nothing happens. P.S. JavaScript on a page like this is very bad.
Yes issue is due to jquery It is breaking the js scripts. Thank. you for pointing out.We are working on it.
Admin
It should work now dear.
error with postgresql scripts, they don’t open when you click on them
please help with postgresql scripts then cannot open
postgres scripts don’t work
Hello,
The links are not working for me, correct?
If possible, how to put it on an onedrive / googledrive and pass it on to us?
Apologies to everyone, I will fix this issue within 2 to 3 hours.
Dear All,
All the links are working fine now. Please provides your suggestions to improve this page.
good site I like it. Post few replication scripts. thanks
Hi,
I just need to compress the WAL and archive files
could you please update it..
Hi ,I use your site very often ,great job
please post replication steps
I will try brother.
Thanks for your work. It’s very helpful.
Hello Team,
Thanks for sharing very good scripts ..
But one thing ..
Is there anyway to get all DB objects like triggers, types, sequences etc.. in single command ? If yes please provide here .
I see list of objects presents in a schema in this Web page …But not for list of objects presents in a Databases .
Please add this script too.
Will add that for sure.
Can I get script to list all objects details for particular schema, Seems the one updated is not working
How to get Privilege/role granted to user in postgres.
— List down table level privileges of user
SELECT table_catalog, table_schema, table_name, privilege_type
FROM information_schema.table_privileges
WHERE grantee = ‘USER_NAME’;
— List down usage privileges of a user:
select * from usage_privileges where grantee=’USER_NAME’;
Thanks, Its showing only your current db. suppose in my cluster I have more than 100+ db
Please give me me query how to get at global level.
Hi,
Could you please upload script to get privilege’s assigned to role.
Hi
Thanks for this notes. I am beginner to Postgres could you please share me installation and configuration of Postgres on Linux pls .
Very good information ..Thanks for compiling all things
Thank you for sharing so many great scripts. but could you also please provide a script that can read errors from the log file and then send the error messages to an email address for notifications?
Thanks so much!
Nice collection, would be nice if can be downloaded as a zip file though 🙂