November 22
Backups are one of the most critical tasks in PostgreSQL administration. Two of the most powerful built-in tools for this are pg_dump and pg_restore.
November 11
Running PostgreSQL on your own virtual machine in the cloud gives you more control, flexibility, and real-world experience than a managed solution. And the best part? You can do it completely free on the Google Cloud Platform (GCP) Free Tier.
November 09
Running PostgreSQL in Docker is a convenient way to manage your database environment. With just a few commands, you can have a fully functional PostgreSQL instance up and running, isolated from your host system.
I’ve spent over 20 years optimizing databases and designing rock-solid data systems. Now I’m sharing what I’ve learned to help others build faster, smarter, and more reliable platforms.
