How do I connect the Postgres database running on the local machine to the docker container

Question

I have a Flask application running on the container and Postgres database on the local machine and Now, I want to connect the Postgres DB (listening on 5432) to the docker container.

Can any one suggest the best way to do it ? (I am new to docker containers)

Thanks in advance.

score 1 · Answer 1 · answered Jun 29 '17 at 20:50

1

You'll likely want to Dockerize your Postgres database in its own container and use a persistent volume to store your data locally.

Tutorial on how to Dockerize your Postgres database: https://docs.docker.com/engine/examples/postgresql_service/

Documentation on Docker volumes: https://docs.docker.com/engine/tutorials/dockervolumes/

Postgres image on Docker Hub: https://hub.docker.com/_/postgres/

answered Jun 29 '17 at 20:50

Mitch

1,374
5
21
39

I have large Postgres database (>50gb) so I think it's not advisable to the same ? – abhishek kavali Jun 29 '17 at 21:01
The size of the database is not really a big deal. The postgres data directory should go in a volume, which is really just a directory on your host. – programmerq Jun 30 '17 at 15:24

so-random-dude · Accepted Answer · 2017-06-29T21:17:03.910

0

You can use the IP address of your local machine to connect to the postgres from your Docker container. localhost will not be resolvable in certain machines.

You may have some interest in this post. From inside of a Docker container, how do I connect to the localhost of the machine?

edited Jun 29 '17 at 21:17

answered Jun 29 '17 at 21:11

so-random-dude

15,277
10
68
113

How do I connect the Postgres database running on the local machine to the docker container

2 Answers2