Questions to ask when provisioning a new database
The following list is a list of questions that a Database Administrator should ask when provisioning a new database. The questions are also useful when examining an existing database as…
The following list is a list of questions that a Database Administrator should ask when provisioning a new database. The questions are also useful when examining an existing database as…
The following scripts backup your PostgreSQL databases via Python using pg_dump. The scripts will then compress the backup via zip. These backup scripts are linux specific. You’ll have to manage…
The following python script gets all databases from a PostgreSQL server.
A list of tasks for Database administrator, regardless of platform.
Create a new user in PostgreSQL
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 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…
The following query is used to view blocking in Postgres.