PostgreSQL

Learn PostgreSQL tablespaces on Ubuntu: create one on another disk, move tables and indexes, set temp_tablespaces and drop it safely, with real output.

PostgreSQL schema vs database explained for DBAs: create databases, use template0, organise schemas and set search_path permanently, with real output.

Create users and group roles in PostgreSQL 18, grant database, schema and table privileges, set default privileges and drop roles safely. Tested steps.

Learn pg_hba.conf on PostgreSQL 18 for Ubuntu: rule order, peer vs scram-sha-256, allowing remote connections, testing rules and fixing login errors.

Learn PostgreSQL DISTINCT ON with real examples: latest row per group, multiple columns, NULLs, ties, row_number() comparison and indexing for speed.

Find postgresql.conf on Ubuntu, read settings with SHOW and pg_settings, and learn which changes need a reload and which need a restart in PostgreSQL 18.

Learn the psql commands a PostgreSQL DBA uses daily: connecting, meta-commands, output formats and safe scripts with ON_ERROR_STOP, on Ubuntu.

What every file and folder in the PostgreSQL 18 data directory on Ubuntu does, how tables map to files, and how to move PGDATA to a new disk safely.

Install PostgreSQL 18 on Ubuntu from the official PGDG repository, then find its files and start, stop and reload it with systemctl and pg_ctlcluster.

Start the PostgreSQL DBA series: what a DBA does, and PostgreSQL architecture explained with real processes, memory settings and files on Ubuntu.

Fix PostgreSQL ERROR: deadlock detected (40P01). Reproduce it, read the log, find blocking sessions and lock rows in a safe order, with real output.

Learn PostgreSQL upsert with INSERT ON CONFLICT DO UPDATE and DO NOTHING: multi-column keys, EXCLUDED, partial indexes, real errors and MERGE.

Learn how FOR UPDATE SKIP LOCKED lets many workers take jobs from one PostgreSQL table without waiting or double work, with real examples and output.