Docker – Postgres and pgAdmin 4 : Connection refused

by

In this case:

  1. Pgadmin fails to connect to localhost, but psql works from outside docker.
  2. both pgadmin & Postgres are running as Containers

Although you haven’t indicated if you are doing so, ideally both containers could be part of a custom bridge network for automatic DNS resolution.

If not added explicitly they will be part of the default bridge network.

To find out the networks created in your docker runtime, type:
$ docker network ls

Some networks will be listed in the console, maybe you’ll find a [name]_default it should be your network.

Execute
docker network inspect [name]_default
it’ll show up a bunch of information, for us the most important is IPv4Address, something like this:
"7c3cd7532ab8aacc70830afb74adad7296d9c8ddd725c498af2d7ee2d2c2aadd": {
"Name": "intime_postegres_1",
"EndpointID": "56a9cb574469f22259497b72719f9f4a3e555b09f95058fcf389ef5287381f28",
"MacAddress": "02:42:ac:12:00:02",
"IPv4Address": "172.18.0.2/16",
"IPv6Address": ""
}

Instead of using localhost for the server name/ip in the pgAdmin new server dialog, connect to the postgres instance’s “IPv4Address”.

In my case connecting at 172.18.0.2:5432, worked like a charm.

More Related Contents:

  1. Connecting to Postgresql in a docker container from outside
  2. How to persist data in a dockerized postgres database using volumes
  3. docker postgres pgadmin local connection
  4. How to customize the configuration file of the official PostgreSQL Docker image?
  5. Docker wait for postgresql to be running
  6. Changing a postgres containers server port in Docker Compose
  7. Docker – How can run the psql command in the postgres container?
  8. Spring Docker container cannot access Postgres Docker container
  9. What is PostgreSQL equivalent to autoincrement?
  10. How do I specify a password to ‘psql’ non-interactively?
  11. INSERT with dynamic table name in trigger function
  12. psql: FATAL: Ident authentication failed for user “postgres”
  13. ECONNREFUSED for Postgres on nodeJS with dockers
  14. Docker Compose + Spring Boot + Postgres connection
  15. What is the format for the PostgreSQL connection string / URL?
  16. Go and IN clause in Postgres
  17. Where does PostgreSQL store the database?
  18. Grant all on a specific schema in the db to a group role in PostgreSQL
  19. Can I make a plpgsql function return an integer without using a variable?
  20. Migrate database from Postgres to MySQL [closed]
  21. How to find out if an upsert was an update with PostgreSQL 9.5+ UPSERT?
  22. Why can I create a table with PRIMARY KEY on a nullable column?
  23. Oracle SQL Developer and PostgreSQL
  24. PostgreSQL array of elements that each are a foreign key
  25. Differentiate inserted and updated rows in UPSERT using system columns
  26. Custom ORDER BY Explanation
  27. PostgreSQL authentication method 10 not supported
  28. now() default values are all showing same timestamp
  29. What’s the difference between pg_table_size, pg_relation_size & pg_total_relation_size? (PostgreSQL)
  30. JPA and PostgreSQL with GenerationType.IDENTITY

Leave a Comment