Loop over PostgreSQL Tables
Rudy The following script loops over some PostgreSQL tables and grabs row counts
PostgreSQL
Move PostgreSQL Data Directory and Config Files
The following code is used to move the PostgreSQL data directory to a new directory.
Davinci Resolve Tables
The following tables were populated by Davinci Resolve after 2 sample projects: schema_name table_name row_count public database_upgrade_log 127 public Gallery::GyMemView_Gallery::GyStillRef 78 public Gallery::GyStillRef 78 public Sm2TiItem 9 public Sm2TiItem_Sm2TiTrack 9…
Jetbrains vs DBeaver
Firstly, DataGrip provides a more robust and user-friendly interface tailored specifically for SQL developers. It offers advanced code completion, on-the-fly analysis, and quick-fixes, which can significantly reduce the time spent…
Streaming Replication
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…
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.