Comments on: POSTGRES DB SCRIPTS

By: Ed

Ed — Wed, 21 Feb 2024 11:26:15 +0000

Nice collection, would be nice if can be downloaded as a zip file though 🙂

By: Allan Sun

Allan Sun — Wed, 27 Dec 2023 22:52:46 +0000

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!

By: phani

phani — Thu, 12 Jan 2023 06:41:54 +0000

Very good information ..Thanks for compiling all things

By: Santhosh

Santhosh — Wed, 28 Dec 2022 02:35:21 +0000

Thanks for this notes. I am beginner to Postgres could you please share me installation and configuration of Postgres on Linux pls .

By: Anik

Anik — Mon, 12 Dec 2022 12:41:54 +0000

In reply to Vasu. Can I get script to list all objects details for particular schema, Seems the one updated is not working

By: Sachin

Sachin — Fri, 31 Dec 2021 12:43:30 +0000

In reply to Admin. 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.

By: Sachin

Sachin — Tue, 14 Dec 2021 13:32:46 +0000

Hi,

Could you please upload script to get privilege’s assigned to role.

By: Admin

Admin — Fri, 19 Nov 2021 16:17:28 +0000

In reply to sachin.

— 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’;

By: sachin

sachin — Fri, 19 Nov 2021 03:26:07 +0000

How to get Privilege/role granted to user in postgres.

By: Admin

Admin — Thu, 01 Jul 2021 09:57:04 +0000

In reply to Vasu. Will add that for sure.