Daily DBA Duties
Rudy A list of tasks for Database administrator, regardless of platform.
postgres
Create PostgreSQL user with all database privileges
Create a new user in PostgreSQL
PostgreSQL Permissions
The following scripts create some tables that store PostgreSQL permissions. The permissions come from the system tables pg_roles, pg_auth_members, and others. The scripts assume there is a database named DBA,…
Read Postgres Configuration File
Read and Display Postgres configuration information The following script reads the Postgresql configuration file and displays key settings. Results are sent to the console and an outfile. You can also…
Postgres Blocking Query
The following query is used to view blocking in Postgres.