Install PostgreSQL on Ubuntu 22.04
Rudy The following scripts install PostgreSQL on Ubuntu 22.04 Installation Steps Perform Updates First install any updates for Ubuntu Add Repository and Install Ubuntu does not include PostgreSQL so we must…
postgresql
Install single instance of PostgreSQL with Ansible
Prerequisites The following Ansible script installs prerequisites. This includes packages for Python, etc. PostgreSQL The following Ansible script installs a single instance of PostgreSQL via ansible.
Backup Script in PG
The following script is for backing up a postgres database Backup Via .env file The following script uses a .env instead of a .pgpass file
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…
PostgreSQL pg_dump backups via Python
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…
Get Databases from a Server
The following python script gets all databases from a PostgreSQL server.
Daily DBA Duties
A list of tasks for Database administrator, regardless of platform.
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…