docker postgres pgadmin local connection
It's a valid question don't know why people feel "doesn't seem possible to answer that question".
So, here's how I do what you are trying to do:
Pull postgres image from Docker Hub
docker pull postgres:latest
Run the container using the below command
docker run -p 5432:5432 postgres
Using docker's inspect command find the IP
Use that IP, PORT, Username, and Password to connect in PGADMIN
You can also do a simple telnet like below to confirm if you can access docker postgres container:
telnet IP_ADDRESS 5432
What I have done success on windows 10 running docker for windows 1.12.6(9655), the step is like below:
Pull the latest postgres
docker pull postgres:latest
run the postgres containner:
docker run -d -e POSTGRES_USER=user -e POSTGRES_PASSWORD=password123 --name db-my -p 5432:5432 --restart=always postgres
Then installed the latest version of pgAdmin4 frompgadmin website
Run pgAdmin 4 create new server, and input as followingHost: 127.0.0.1Port: 5432User name: userpassword: password123
- Then everything is ok, connect to docker postgres instance success.
Alternatively, you could combine Postgres and Pgadmin in one docker-compose
file, and login as user pgadmin4@pgadmin.org
, pwd: admin
. To add the Posgres server, use hostname postgres
, port 5432
.
version: '3'services: postgres: image: postgres hostname: postgres ports: - "6543:5432" environment: POSTGRES_USER: postgres POSTGRES_PASSWORD: postgres POSTGRES_DB: TEST_SM volumes: - postgres-data:/var/lib/postgresql/data restart: unless-stopped pgadmin: image: dpage/pgadmin4 depends_on: - postgres ports: - "5555:80" environment: PGADMIN_DEFAULT_EMAIL: pgadmin4@pgadmin.org PGADMIN_DEFAULT_PASSWORD: admin restart: unless-stoppedvolumes: postgres-data: