Streaming Replication
Rudy Streaming1 In PostgreSQL, streaming replication is a process that allows data from a primary server (also called the master) to be replicated in real-time to one or more secondary servers…
PostgreSQL
Compare perms in PostgreSQL
Compare permissions between two roles in PostgreSQLyea.
PostgreSQL Transactions
The following query lists open PostgreSQL transactions
PostgreSQL Locks
The following script displays PostgreSQL locks The following lists blocking activity
Install PostgreSQL on Ubuntu 22.04
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…
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.
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…