How to Install PostgreSQL Using Docker and Docker Compose ?

Installing PostgreSQL using Docker and Docker Compose is a straightforward process. Docker allows you to package an application and its dependencies into a container, making it easy to deploy and run consistently across different environments.

Here are the steps to install PostgreSQL using Docker and Docker Compose:

Ensure that Docker and Docker Compose are installed on your machine. You can download and install Docker from the official Docker website and Docker Compose from the Docker Compose GitHub releases page.

Create a file named docker-compose.yml in your project directory. This file will define the services, networks, and volumes for your PostgreSQL container.

# docker-compose.yml

version: '3'

services:
  postgres:
    image: postgres:latest
    restart: always
    environment:
      POSTGRES_DB: your_database_name
      POSTGRES_USER: your_username
      POSTGRES_PASSWORD: your_password
    ports:
      - "5432:5432"
    volumes:
      - postgres_data:/var/lib/postgresql/data

volumes:
  postgres_data:

Replace your_database_name, your_username, and your_password with the desired values for your PostgreSQL database.

Open a terminal in your project directory and run the following command to start the PostgreSQL container:

docker-compose up -d

This command will pull the PostgreSQL image from Docker Hub, create a container based on the configuration in your docker-compose.yml file, and run it in the background (-d flag).

You can now access your PostgreSQL database using a database client or command-line tools. The default PostgreSQL port is 5432.

• Host: localhost or 127.0.0.1
• Port: 5432
• Username: The username you specified in the docker-compose.yml file
• Password: The password you specified in the docker-compose.yml file
• Database: The database name you specified in the docker-compose.yml file

When you're done working with PostgreSQL, you can stop and remove the container using the following command:

docker-compose down

This will stop and remove the PostgreSQL container, but the data will persist in the postgres_data volume defined in the docker-compose.yml file.

By following these steps, you can easily set up and run a PostgreSQL instance using Docker and Docker Compose.