Docker-Compose Setup for Database

[Chazzvdh]

Utilize Docker Compose to orchestrate the setup of a PostgreSQL database in a Docker container, ensuring ease of deployment and management.

Requirements

Functional requirements

• Docker Compose should be installed on your development machine.
• PostgreSQL image should be specified in the docker-compose.yml file.
• Configuration should be provided for initializing the database with a custom schema and data (if required).
• Define environment variables for PostgreSQL configuration such as database name, username, and password.
• Expose the PostgreSQL port for connecting to the database from your development environment.

Non-functional requirements

• Ensure proper volume mounting to persist database data beyond container restarts.

docker-compose.yml Example

version: '3.8'

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

volumes:
  db_data:

Usage Instructions

1. Save the docker-compose.yml file in your project directory.
2. Open a terminal and navigate to your project directory.
3. Run the following command to start the PostgreSQL database:

   docker-compose up -d

4. To stop the database, use:

   docker-compose down

Additional Notes

• Ensure that environment variables such as POSTGRES_DB, POSTGRES_USER, and POSTGRES_PASSWORD are set securely.
• Customize the docker-compose.yml file according to your specific database requirements.
• Verify connectivity to the PostgreSQL database from your development environment after starting the container.