tristan tristantreb
tristantreb
/ conn_status.sql
Created
June 27, 2023 13:58
PostgreSQL connection status (used, res_for_super, max_conn)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select * from | |
| (select count(*) used from pg_stat_activity) q1, | |
| (select setting::int res_for_super from pg_settings where name=$$superuser_reserved_connections$$) q2, | |
| (select setting::int max_conn from pg_settings where name=$$max_connections$$) q3; |
tristantreb
/ read-access.sql
Created
June 5, 2023 16:35
— forked from oinopion/read-access.sql
How to create read only user in PostgreSQL
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Create a group | |
| CREATE ROLE readaccess; | |
| -- Grant access to existing schemas & tables, and to future tables (as of now you can't grant access to future schemas) | |
| DO | |
| $do$ | |
| DECLARE | |
| sch text; | |
| BEGIN | |
| FOR sch IN |