Postgres DB multi-instance (v12 and v14) setup in docker with pgAdmin based management
Prodramp
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/publiccode/blob/master/postgresql-docker-scripts/postgresql-docker-script.md
Please visit: https://prodramp.com @prodramp
Content Creator: Avkash Chauhan (@avkashchauhan) ... https://www.youtube.com/watch?v=thak0TV-d2c
2022-10-11
0.0 LBC
Copyrighted (contact publisher)
120892413 Bytes