Tools & DevOps

PostgreSQL Extensions Worth Installing

Michael Patrick McCoy

PostgreSQL’s extension system is one of its greatest strengths. From performance tuning with pg_stat_statements to UUID generation, encryption, and even geospatial queries with PostGIS, here are the extensions every developer should know!


Read More

PostgreSQL Backups: Using pg_dump and pg_restore

Michael Patrick McCoy

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.


Read More

Installing PostgreSQL On GCP Free Tier

Michael Patrick McCoy

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.


Read More

Install PostgreSQL In Docker

Michael Patrick McCoy

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.


Read More