postgresql-docker

name	postgresql-docker
description	PostgreSQL in containers - Docker, Kubernetes, production configs
version	3.0.0
sasmp_version	1.3.0
bonded_agent	08-postgresql-devops
bond_type	SECONDARY_BOND
category	database
difficulty	intermediate
estimated_time	2h

PostgreSQL Docker Skill

Atomic skill for containerized PostgreSQL

Overview

Production-ready patterns for Docker and Kubernetes PostgreSQL deployments.

Prerequisites

• Docker or Kubernetes
• Understanding of volumes
• Resource planning

Parameters

parameters:
  platform:
    type: string
    required: true
    enum: [docker, kubernetes, compose]
  environment:
    type: string
    enum: [development, staging, production]

Quick Reference

Docker Compose

version: '3.8'
services:
  postgres:
    image: postgres:16-alpine
    environment:
      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
      PGDATA: /var/lib/postgresql/data/pgdata
    volumes:
      - postgres_data:/var/lib/postgresql/data
    ports:
      - "5432:5432"
    healthcheck:
      test: ["CMD-SHELL", "pg_isready"]
      interval: 10s
    deploy:
      resources:
        limits: