
How to Migrate PostgreSQL to the Cloud: AWS RDS, Aurora, Azure and Google Cloud SQL
Short answer: For small databases that can take a short outage, use pg_dump and pg_restore to move PostgreSQL to a managed cloud service. For large…

Short answer: For small databases that can take a short outage, use pg_dump and pg_restore to move PostgreSQL to a managed cloud service. For large…

Your PostgreSQL server is running low on memory. Maybe you saw the Linux OOM killer in the logs, or free -h shows…

The database is slow, CPU is at 90%, and someone asks, “Which query is doing this?” PostgreSQL can tell you,…

You probably have a clear picture of a table: rows of data, one after another. A books table holds books. A users table holds…

Sooner or later you need the CREATE TABLE statement for a table that already exists. Maybe you want to copy it to…

A query that took 5 milliseconds last month now takes 5 seconds. Nine times out of ten, the first question…

A table without a primary key can look perfectly normal. Queries run, and data goes in and out. Then one…

Short answer: PostgreSQL doesn’t record when a table was created. No system catalog has a created_at column, and nothing in pg_class or pg_stat_user_tables stores it. That surprises a…

You can change a PostgreSQL password with one SQL statement. The part people get wrong is how they type it. Done the…

You can change an Ubuntu hostname with a single command. There are two things to watch for: /etc/hosts still points to the…