it is very convenient to spin up a Postgres Database in the docker by composing a docker compose yaml file.
the following code will help us setup a Postgres Database in the Docker
version: '3.8'
services:
twitter_postgres_db:
image: debezium/postgres:13-alpine
environment:
- POSTGRES_DATABASE=twitter_db
- POSTGRES_USER=twitter_dev
- POSTGRES_PASSWORD=twitter_dev
ports:
- 6543:5432
volumes:
- twitter_db_data:/data/db
volumes:
twitter_db_data:
I should be able to setup another container for the PgAdmin in the docker. Since I already install a Postgres PgAdmin instance in my desktop. I just want to access the Postgres Database from my local host.
Here is the step that we should follow to access the Postgres from local PgAdmin
1. Register the localhost Server
2. Fill the following information in the Register Server Window
- Name: LocalHost
- Host Name /Address: localhost
- Port: 6543 (copied from the docker compose file)
- Maintenance Database: twitter_db (copied from the docker compose file)
- Username: twitter_dev (copied from the docker compose file)
- Password: twitter_dev (copied from the docker compose file)
3. After I click on the save button, then you should be able to access the Twttier_db
