loading...
Cover image for How To Install and Run PostgreSQL using Docker ?

How To Install and Run PostgreSQL using Docker ?

shree_j profile image ShreeJ ・3 min read

Installing, running and managing postgres in local-machine for development is not difficult anymore. Here is a simple way to get all at one place easily installed and configured within seconds with the help of docker.

Now skip all complex steps in installing and configuring PSQL to get started with local development and GUI to manage the DB. It's now easy to kick-start development of postgres based applications in a few seconds.

NOTE: This is to make the development process easy and however follow the conventional method of installing PSQL individually for production environment.

After following the instructions below, you will get the following installed in your machine:

  1. Postgres server running as a docker-container (which can be accessed by CLI, GUI or other application for development).
  2. Postgres container accessible through CLI.
  3. PgAdmin4 browser version to access Postgres server from GUI.

Prerequisite:

  1. Install docker
  2. … nothing else :)

Install and Configure PSQL using Docker:

Run the below command in linux or windows or mac machine from the terminal or command-prompt to pull PSQL from docker-hub.

docker run --name postgresql-container -p 5432:5432 -e POSTGRES_PASSWORD=somePassword -d postgres

In the above command replace :

  • Optional - postgresql-container with a preferable container name if necessary.
  • somePassword with a password to authenticate and connect to the postgres (in application with connection string as well as the PG-admin viewer).

Verify a new container created and running at 0.0.0.0:5432 with the below command.
docker ps -a

psql_install

The PostgresQL is ready to connect and use.

The postgres server is now running in the IP of your local machine in 5432.

Install PG-admin using Docker:

Download the pgAdmin-4 browser version from docker-hub using the following command.

docker run --rm -p 5050:5050 thajeztah/pgadmin4

Now manage your postgres from the browser by launching http://localhost:5050 .

pg_admin_install

To connect the PSQL server in pgAdmin:

pg_admin_1

Enter the credentials to save and manage PSQL via GUI.
Host - The IP address of your machine
Password - Password used while creating the PSQL server with docker

pg_admin_cred

Connecting to the PSQL server via CLI :

The steps below are to connect to the psql server from CLI :

  1. Find the docker-container-id in which the postgres is running using the below command. docker ps -a
  2. Run the below command to enter into the container (with the ID from step-1). docker exec -it <PSQL-Container-ID> bash
  3. Authenticate to start using as postgres user. psql -h localhost -p 5432 -U postgres -W
  4. Enter the password used while creating the PSQL server container.

psql_cli

Connecting to the PSQL server via application :

(example: JavaScript)

const { Client } = require('pg');

let client = new Client({
  connectionString: "postgresql://postgres:test1234@192.168.225.86:5432/postgres"
});

const connectDB = async () => {
  try {
    console.log('Connect to Postgres ...');
    client.connect();
    await new Promise((resol, rej) => {
      client.query('Select now() as run_at;', (err, res) => {
        if(err) {
          console.log(err);
          reject(err);
        } else {
          console.log(`Run at date-time : ${res.rows[0].run_at}`);
          resol(res.rows[0].run_at);
        }
      })
    });
    await client.end();
    console.log('Execution Completed ...');
  } catch (err) {
    console.log('Error while Connecting DB !')
  }
}

connectDB();

Posted on by:

Discussion

markdown guide
 

Hi thanks for this article but when I do this. PGAdmin gets installed and started but when I try to access it on browser with localhost:5050 but it is not working. It shows site can't be reached.

 

Ensure the docker container is up and running :
docker ps -a

 

Yes it is running and shows that open 0.0.0.0: , but still not able to access on browser.

 

Thats really well written, good job 👏

 

Hey great article! But why not use Docker for production environment?!

 

Its not about using docker for production environment.
As the DB is hosted in a container and not attached to any volume, once we delete the container (like docker rm <container_id>), the data in DB will be lost permanently.
Which will not be the way a production app should work.

 

I agree with Marcos...nice article J Shree! :-)

It might also be helpful to show folks how to save their data even after running docker rm <container_id>. This is how I normally accomplish this:

First, create a local directory to hold the data:

mkdir -p /home/<your_user_id_here>/pgdata

Then start PostgreSQL using a volume mount so the container will store the data in this newly created local directory:

docker run \
  -d \
  --name postgresql-container \
  -p 5432:5432 \
  -e POSTGRES_PASSWORD=somePassword \
  -v /home/<your_user_id_here>/pgdata:/var/lib/postgresql/data \
  postgres

Using this method, you can be safe in knowing that even if you accidentally run docker rm <container_id> that you can restart PostgreSQL again and have all of you data just as you left it previously.

Hope this helps!