mkdir -p /opt/docker/postgresql/{data,logs}

chown -R 999:999 /opt/docker/postgresql/logs
chmod -R 755 /opt/docker/postgresql/logs

version: '3.8'

services:
  postgres:
    image: postgres:latest
    container_name: postgres_container
    environment:
      - POSTGRES_USER=postgres
      - POSTGRES_PASSWORD=mypassword
      - POSTGRES_DB=postgres
    ports:
      - "5432:5432"
    volumes:
      - /opt/docker/postgresql/data:/var/lib/postgresql/data
      - /opt/docker/postgresql/logs:/var/log/postgresql
    restart: always
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U postgres || exit 1"]
      interval: 30s
      timeout: 10s
      retries: 5
    networks:
      - postgres_network
  
networks:
  postgres_network:
    driver: bridge

docker-compose up -d

# Connection and Language Settings
listen_addresses = '*'                       # Allow external connections
default_text_search_config = 'pg_catalog.english'

# Memory and Cache Settings
shared_buffers = 2GB                         # Set shared memory buffer to 2GB
work_mem = 8MB                               # Set per-operation work memory

# WAL (Write-Ahead Logging) Settings
max_wal_size = 2GB                           # Prevent frequent checkpoints
min_wal_size = 512MB                         # Minimum WAL size

# Logging Configuration
log_destination = 'stderr'
logging_collector = on
log_directory = '/var/log/postgresql'        # Set log directory to mounted volume
log_filename = 'postgresql-%Y-%m-%d.log'
log_min_duration_statement = 1000            # Log queries longer than 1s
log_rotation_age = '1d'                      # Rotate logs daily
log_rotation_size = '100MB'                  # Rotate logs when they reach 100MB

# PostgreSQL Client Authentication Configuration File
# ====================================================
# TYPE  DATABASE        USER            ADDRESS                 METHOD

# Local connections
local   all             all                                     trust

# Loopback connections
host    all             all             127.0.0.1/32            trust
host    all             all             ::1/128                 trust

# replication privilege.
local   replication     all                                     trust
host    replication     all             127.0.0.1/32            trust
host    replication     all             ::1/128                 trust


# Allow all external connections with scram-sha-256 authentication
host    all             all             0.0.0.0/0            scram-sha-256

docker restart postgres_container

docker exec -it postgres_container psql -U myuser -d mydatabase