Overview
Learn how to set up and manage multiple instances of PostgreSQL databases (versions 12 and 14) using Docker and pgAdmin in this hands-on tutorial. Discover how to use docker-compose scripts to launch PostgreSQL databases, utilize Docker Desktop for setup and management, and solve host port conflicts when running multiple instances. Gain practical experience in managing PostgreSQL databases through both command-line interfaces and pgAdmin tools. Explore quick tips and tricks for efficient database management while running different versions side by side. Follow along with a detailed timeline covering installation, setup, management, and a comprehensive recap of the process.
Syllabus
- Start of Tutorial
- Intro
- pgAdmin and Docker installation
- Using docker-compose script to launch Postgres DB
- Using Docker Desktop to setup and manage Postgres DB instance
- Using pgAdmin manage Postgres DB instance
- Command line access to Postgres DB Instance
- Updating docker-compose script to run both v12 and v14 Postgres DB side by side
- Both Postgres version 12.x and 14.x running side by side
- Managing both Postgres DB v12 and v14 side by side using pgAdmin
- Recap
Taught by
Prodramp