Security in Google Cloud Platform. Launch your Career in Cloud Security.
Introduction to TensorFlow for AI, ML, and DL.
Build AI Powered Chatbots without Programming

How do I connect to Postgresql running on host from Docker container

There could be instances where you want to connect to Postgresql database on the host from your containers.In this post,we take look at configuration steps on how to connect to Postgresql running on host from your Docker containers.

We are going to use Docker Compose tool to define and run multi-container applications.We would be defining compose configuration as YAML file for our application’s services/networks/volumes etc., and then with a single command, we can create and start all the services from the configuration.

Here are the key steps :

  1. Define Dockerfile for your app’s environment.
  2. Define docker-compose.yml for the services that make up your app services.
  3. Configure Postgresql to able to connect from Docker containers.
  4. Run docker-compose up and Compose starts and runs your entire app.

This quickstart assumes basic understanding of Docker concepts, please refer earlier posts for understanding on Docker & how to install and containerize applications.

In the next section,we can look at how define services in compose file for sample application with Angular as front end,Spring Boot as API and  for database as Postgres but this will be located on the host.

Get your Zoom Pro account for as low as $12.49/month with annual plan ($14.99/month without). Host up to 100 participants on HD video, record meetings to the cloud, share content, annotate, chat, and more!

#1.Definition of Docker files

We have already defined below docker files in the previous posts herehere.Create new project directory and copy all dockerfiles to this folder.

Subscribe to Emails

More than 1000+ subscribers across the world trust & read Upnxtblog articles. Subscribe to emails updates!
* indicates required

Angular Application Docker file

FROM httpd:2.4
#copy angular dist folder to container 
COPY dist/ /usr/local/apache2/htdocs/

#copy htaccess and httpd.conf to container
COPY .htaccess /usr/local/apache2/htdocs/
COPY httpd.conf /usr/local/apache2/conf/httpd.conf

#change permissions
RUN chmod -R 755 /usr/local/apache2/htdocs/

#expose port
EXPOSE 4200

Spring Boot API Docker file

FROM openjdk:8-jre
WORKDIR /
#add required jars
ADD spring-boot-rest-postgresql-0.0.1-SNAPSHOT.jar spring-boot-rest-postgresql-0.0.1-SNAPSHOT.jar

#expose port
EXPOSE 8080
#cmd to execute
ENTRYPOINT ["java","-Djava.security.egd=file:/dev/./urandom","-jar","/spring-boot-rest-postgresql-0.0.1-SNAPSHOT.jar"]

#2.Define services in Docker compose file

Create a file called docker-compose.yml in your project directory and paste the following:

version: '3'
services:
   ui:
    build:
      context: .
      dockerfile: UIDockerfile
    ports:
      - '4200:4200'
    networks:
      - samplenet
    links:
      - 'api:api'
  api:
   build:
     context: .
     dockerfile: AppDockerfile
   ports:
     - '8080:8080'
   networks:
    - samplenet
networks:
samplenet: null

 

Above compose file defines 2 services as below:

  • ui : This is for angular application,it uses an image that’s built from the UIDockerfile in the current directory and forwards the exposed port 4200 on the container to port 4200 on the host machine.
  • api : This is for spring boot application,it uses an image that’s built from the AppDockerfile in the current directory and forwards the exposed port 8080 on the container to port 8080 on the host machine.
  • All the above services uses samplenet network
  • depends_on denotes the service dependencies.When you start the services, compose would start the dependent services as well.
  • If you have noticed,we haven’t created service for Postgresql application instead we would be using Postgresql database installed on the host.
  • Also on your SpringBoot configuration (application.properties file) specify the external IP address of the database host like  spring.datasource.url=jdbc:postgresql://<IP Address>:5432/postgres

#3.Configure Postgresql to able to connect from Docker containers

Assuming Postgresql is already installed on the host machine,follow the below steps to configure the listen_addresses on postgresql.conf to accept all connections.

listen_addresses

Image – Modify postgresql.conf

Also edit pg_hba.conf  file to add entry for the host connections like below

host        all         all          0.0.0.0/0           md5

host connections

Image – Add entries for host connections

#4.Build and run your app with Compose

Once you have completed the above configurations,next step is to start the application.In the current project directory, run docker-compose up .Compose pulls all the required docker image, builds an image for your code, and starts the services you defined.

Image – Start containers using docker-compose up command

Image – Both containers are up

Congrats! today we have learnt how to configure Postgresql running on host to be able to connect from Docker containers.

Like this post? Don’t forget to share it!

Additional Resources:



Summary
How do I connect to Postgresql running on host from Docker container
Article Name
How do I connect to Postgresql running on host from Docker container
Description
In this post,we take look at configuration steps on how to connect to Postgresql running on host from your Docker containers.
Author
Publisher Name
Upnxtblog
Publisher Logo
%d bloggers like this: