Skip to content

README.md

Latest commit

 

History

History
79 lines (58 loc) · 3 KB

README.md

File metadata and controls

79 lines (58 loc) · 3 KB

PostgreSQL Docker Images

Important

Maintained by Panubo — Cloud Native & SRE Consultants in Sydney. Work with us →

Supported tags

Images are available at quay.io/panubo/postgres or public.ecr.aws/panubo/postgres.

  • 12-bullseye, 12.14-bullseye, 12.14-2.9.3-bullseye, 12-2.9-bullseye
  • 9.6-to-12-upgrade
  • 9.6-dev, 9.6-1.6-dev

All future images will use the OS name and version instead of codenames

Testing tags

These images are being tested.

  • 14-debian11, 14.7-debian11, 14.7-2.5.2-debian11, 14-2.5-debian11

Extensions

These Docker images for PostgreSQL include a few improvements to the official images.

Image PostgeSQL TimescaleDB PostGIS pglogical
12-bullseye 12 2.5.2, 2.9.3 2.5.5 2.4.1
14-debian11 14 2.5.2 3.1.8 2.4.2

REF:

PostGIS Support Matrix

Timescale versions

Timescale Release Notes

TS / PG PG 12 PG 14
2.5.X ✓ ✓
2.6.X ✓ ✓
2.7.X ✓ ✓
2.8.X ✓ ✓
2.9.X ✓ ✓
2.10.X ✓ ✓

Upgrade

docker run --rm -i -v $(DATA_DIR):/var/lib/postgresql -e POSTGRES_PASSWORD=password panubo/postgres:9.6-to-12-buster-upgrade -O "-c timescaledb.restoring='on'" --link

Known Upgrade Issues

  • The VIEW created by prometheus-exporter can cause pg_upgrade to fail. If this occurs you should remove postgres_exporter.pg_stat_activity and re-install post upgrade with /usr/local/bin/docker-initdb-run /docker-entrypoint-initdb.d/prometheus-exporter.sh.
  • Postgres images 9.6-dev and 12 have POSTGRES_INITDB_ARGS="--data-checksum" by default which will conflict if the source was not using data checksum. You can set POSTGRES_INITDB_ARGS="" to avoid the issue during upgrade.
  • The 9.6-to-12-upgrade image does NOT support timescaledb upgrade.

Important

About Panubo

This project is maintained by Panubo, a technology consultancy based in Sydney, Australia. We build reliable, scalable systems and help teams master the cloud-native ecosystem.

We are available for hire to help with:

  • SRE & Operations: Improving system reliability and incident response.
  • Platform Engineering: Building internal developer platforms that scale.
  • Kubernetes: Cluster design, security auditing, and migrations.
  • DevOps: Streamlining CI/CD pipelines and developer experience.
  • See our other services

Need a hand with your infrastructure? Let’s have a chat or email us at team@panubo.com.