Connecting to Postgresql in a docker container from outside

by

You can run Postgres this way (map a port):

docker run --name some-postgres -e POSTGRES_PASSWORD=mysecretpassword -d -p 5432:5432 postgres

So now you have mapped the port 5432 of your container to port 5432 of your server. -p <host_port>:<container_port> .So now your postgres is accessible from your public-server-ip:5432

To test:
Run the postgres database (command above)

docker ps
CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                     NAMES
05b3a3471f6f        postgres            "/docker-entrypoint.s"   1 seconds ago       Up 1 seconds        0.0.0.0:5432->5432/tcp    some-postgres

Go inside your container and create a database:

docker exec -it 05b3a3471f6f bash
root@05b3a3471f6f:/# psql -U postgres
postgres-# CREATE DATABASE mytest;
postgres-# \q

Go to your localhost (where you have some tool or the psql client).

psql -h public-ip-server -p 5432 -U postgres

(password mysecretpassword)

postgres=# \l

                             List of databases
   Name    |  Owner   | Encoding |  Collate   |   Ctype    |   Access privileges
-----------+----------+----------+------------+------------+-----------------------
 mytest    | postgres | UTF8     | en_US.utf8 | en_US.utf8 |
 postgres  | postgres | UTF8     | en_US.utf8 | en_US.utf8 |
 template0 | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres

So you’re accessing the database (which is running in docker on a server) from your localhost.

In this post it’s expained in detail.

More Related Contents:

  1. How to persist data in a dockerized postgres database using volumes
  2. docker postgres pgadmin local connection
  3. How to customize the configuration file of the official PostgreSQL Docker image?
  4. Docker wait for postgresql to be running
  5. Changing a postgres containers server port in Docker Compose
  6. Docker – How can run the psql command in the postgres container?
  7. Docker – Postgres and pgAdmin 4 : Connection refused
  8. Spring Docker container cannot access Postgres Docker container
  9. What to do with null values when modeling and normalizing?
  10. Postgres: INSERT if does not exist already
  11. How to create User/Database in script for Docker Postgres
  12. Adding ‘serial’ to existing column in Postgres
  13. Making sense of Postgres row sizes
  14. Time zone names with identical properties yield different result when applied to timestamp
  15. Permission denied for relation
  16. CONSTRAINT to check values from a remotely related table (via join etc.)
  17. How do I get a column with consecutive, increasing numbers, without having any numbers missing?
  18. Execute a dynamic crosstab query
  19. Copy a table from one database to another in Postgres
  20. User defined variables in PostgreSQL
  21. psql: FATAL: database “” does not exist
  22. Postgres FOR LOOP
  23. Storing Images in PostgreSQL
  24. Strange behaviour in Postgresql
  25. Postgres: Distinct but only for one column
  26. In PostgreSQL, how to insert data with COPY command?
  27. Cursor based records in PostgreSQL
  28. Configuration parameter work_mem in PostgreSQL on Linux
  29. How to work with PGpoint for Geolocation using PostgreSQL?
  30. PostgreSQL composite primary key

Leave a Comment