How to access Postgres Database host in the Docker?

 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