How to Create PostgreSQL Database with Docker?

How to Create PostgreSQL Database with Docker?

In the dynamic landscape of modern software development, containerization has become a key player, offering scalability, flexibility, and ease of deployment. Docker, a popular containerization platform, allows developers to encapsulate applications and their dependencies into lightweight, portable containers. In this article, we will delve into the process of creating a PostgreSQL database using Docker, providing step-by-step instructions and practical examples to guide you through the setup.

  1. Setting Up Docker:
    Before diving into PostgreSQL, ensure that Docker is installed on your system. You can download Docker from the official website ( and follow the installation instructions provided for your specific operating system.

  2. Pulling the PostgreSQL Docker Image:
    Once Docker is installed, the next step is to pull the PostgreSQL Docker image. Open a terminal or command prompt and use the following command:

    docker pull postgres

    This command fetches the latest PostgreSQL image from the Docker Hub.

  3. Creating a PostgreSQL Container:
    After pulling the PostgreSQL image, create a container using the following command:

    docker run --name my_postgres_container -e POSTGRES_PASSWORD=mysecretpassword -d postgres
    • --name: Assigns a name to the container (in this case, "my_postgres_container").
    • -e POSTGRES_PASSWORD: Sets the password for the PostgreSQL user.
  4. Accessing the PostgreSQL Container:
    To interact with the PostgreSQL database within the container, you can use the docker exec command. For example:

    docker exec -it my_postgres_container psql -U postgres

    This command opens a PostgreSQL prompt where you can execute SQL queries and manage your database.

  5. Creating a Database:
    Inside the PostgreSQL prompt, you can create a new database using SQL commands. For instance:

    CREATE DATABASE mydatabase;
  6. Additional Configuration:
    You might want to expose the PostgreSQL port to access it from outside the container. When creating the container, add the -p option:

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

    This maps the container's PostgreSQL port (5432) to the host machine's port (also 5432).

  7. Stopping and Removing the Container:
    When you're done working with the PostgreSQL container, you can stop and remove it using these commands:

    docker stop my_postgres_container
    docker rm my_postgres_container

Related Searches and Questions asked:

  • Does Docker Use Postgres?
  • How to Run PostgreSQL in Docker?
  • What is Docker libcontainer?
  • How Does Docker Work?
  • That's it for this topic, Hope this article is useful. Thanks for Visiting us.