PostgreSQL

Posted

PostgreSQL is a powerful, open source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.

# file: `docker-compose.yml`

services:
  postgres:
    image: ${HONEYPI_IMAGE_REGISTRY_HOST:-docker.io}/postgres:${HONEYPI_POSTGRES_VERSION:-latest}
    container_name: postgres
    restart: unless-stopped
    command: postgres -c 'max_connections=200'
    shm_size: 128mb
    ports:
      - ${HONEYPI_POSTGRES_PORT:-5432}:5432
    volumes:
      - ${HONEYPI_DATA}/postgres/data:/var/lib/postgresql/data
      - ${HONEYPI_CONFIG}/postgres/init.sql:/docker-entrypoint-initdb.d/init.sql
    environment:
      - POSTGRES_USER=${HONEYPI_POSTGRES_USER:-admin}
      - POSTGRES_PASSWORD=${HONEYPI_POSTGRES_PASSWORD}
      - PGDATA=${HONEYPI_POSTGRES_PGDATA:-/var/lib/postgresql/data/pgdata}