postgresql - docker postgres pgadmin local connection

Question

I have created an ubuntu image with nginx, php and postgres.

I want to connect the postgres database in my current image with pgadmin located on my local machine.

I have tried using docker inspector to try to use the image ip to make a connection with my local pgadmin but without much success. I've also tried configuring some ports on local to make connection work.

Answer 1

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:

1. Pull postgres image from Docker Hub

   docker pull postgres:latest
   

2. Run the container using the below command

   docker run -p 5432:5432 postgres
   

3. Using docker's inspect command find the IP

4. Use that IP, PORT, Username, and Password to connect in PGADMIN

5. You can also do a simple telnet like below to confirm if you can access docker postgres container:

   telnet IP_ADDRESS 5432