Postgres DB multi-instance (v12 and v14) setup in docker with pgAdmin based management

Опубликовано: 14 Январь 2022
на канале: 650 AI Lab
572
12

In this hands-on tutorial you will learn the following:
Postgres DB Setup in Docker
Using docker-compose script to launch Postgres DB
Using Docker Desktop to setup and manage Postgres DB instance
Both Postgres version 12.x and 14.x running side by side
Solving host port conflict with multiple Postgres running at host
Managing Postgres DB with command line and pgAdmin tool
Quick tips and tricks with Postgres DB management

The video timeline is as below:
(00:00) Start of Tutorial
(00:06) Intro
(1:35) pgAdmin and Docker installation
(4:10) Using docker-compose script to launch Postgres DB
(5:20) Using Docker Desktop to setup and manage Postgres DB instance
(6:40) Using pgAdmin manage Postgres DB instance
(8:10) Command line access to Postgres DB Instance
(11:00) Updating docker-compose script to run both v12 and v14 Postgres DB side by side
(11:30) Both Postgres version 12.x and 14.x running side by side
(14:00) Managing both Postgres DB v12 and v14 side by side using pgAdmin
(15:24) Recap

Script URL in Tutorials:
https://github.com/prodramp/publiccod...

Please visit:
https://prodramp.com
@prodramp

Content Creator:
Avkash Chauhan (@avkashchauhan)