PostgreSQL Upgrade Images 1.0.14

PostgreSQL Upgrade Images Release 1.0.14

Available Images

PostgreSQL 16 (Current: 16.10)

• ghcr.io/flanksource/postgres:16 - Latest PostgreSQL 16 major version
• ghcr.io/flanksource/postgres:16.10 - Specific minor version
• ghcr.io/flanksource/postgres:16.10-8321155 - Version with commit SHA

PostgreSQL 17 (Current: 17.6)

• ghcr.io/flanksource/postgres:17 - Latest PostgreSQL 17 major version
• ghcr.io/flanksource/postgres:17.6 - Specific minor version
• ghcr.io/flanksource/postgres:17.6-8321155 - Version with commit SHA

Usage

Basic Upgrade

docker run --rm \
  -v /path/to/pgdata:/var/lib/postgresql/data \
  ghcr.io/flanksource/postgres:17

Upgrade and Start PostgreSQL

docker run -d \
  -v /path/to/pgdata:/var/lib/postgresql/data \
  -e START_POSTGRES=true \
  -p 5432:5432 \
  ghcr.io/flanksource/postgres:17

Supported Upgrade Paths

• PostgreSQL 14 → 15, 16, 17
• PostgreSQL 15 → 16, 17
• PostgreSQL 16 → 17

Sequential upgrades are performed automatically (e.g., 14→15→16→17).

Environment Variables

• PG_VERSION: Target PostgreSQL version (16 or 17)
• START_POSTGRES: Start PostgreSQL after upgrade (default: false)
• AUTO_UPGRADE: Enable auto-upgrade (default: true)
• RESET_PASSWORD: Reset password on startup (default: false)
• POSTGRES_PASSWORD: Password for reset (required if RESET_PASSWORD=true)

Architecture Support

All images support both linux/amd64 and linux/arm64 architectures (built natively on respective runners).

Build Information

• AMD64 builds: Native build on ubuntu-latest
• ARM64 builds: Native build on ubuntu-24.04-arm
• Manifests: Merged using Docker Buildx imagetools

postgres-cli

Download the CLI binary for your platform:

• Linux AMD64
• Linux ARM64
• macOS AMD64
• macOS ARM64 (Apple Silicon)

Checksums are automatically generated by GitHub for all release assets.

What's Changed

• Fix multi-arch Docker build by @adityathebe in #25
• Add database initialization with custom user and database by @adityathebe in #31
• fix: error handling by @adityathebe in #32

Full Changelog: v1.0.11...v1.0.14