spilo

• Add timescaledb-toolkit extension (@ShutterQuick)
• Add function for listing statuses of the active pg_cron jobs as a non-admin user (@FxKu)
• Enforce search_path=pg_catalog in the scripts (@hughcapet)
• Add PyYAML 6.0 compatibility code (@hughcapet)
• Use proper parameters in the pgqd ini file (@hughcapet)

• Patroni 3.0.1
• timescaledb 2.10.0

• Add PostgreSQL 15, remove PostgreSQL 9.6 (@hughcapet, @CyberDem0n)
• Use Ubuntu 22.04 as the base image (@hughcapet, @CyberDem0n)
• Add workflow for multiarch builds (@mmoscher)
• Pass AWS STS regional endpoints environment variable to WAL-G (@ThomasK33)
• Support Service Principal for WAL-G backup to Azure (@stephan2012)

• Patroni 2.1.5
• wal-g v2.0.1
• timescaledb 2.9.1
• PostGIS 3.3
• plprofiler 4.2.1
• pg_profile 4.1

*All extensions, except timescaledb and pllua support PG15

Image: ghcr.io/zalando/spilo-15:2.1-p9

• Disable WAL archiving during major upgrade for the target version
• Allow setting primary_slot_name for standby cluster
• Pass AWS EKS IRSA environment variables to WAL-G
• Drop pg_repack before pg_upgrade --check
• Added https://github.com/zubkov-andrei/pg_profile
• timescaledb 2.7.2
• wal-g v2.0.1

Image: registry.opensource.zalan.do/acid/spilo-14:2.1-p7

• Make it possible to specify a timeout for the restore_command
• Added CLONE_TARGET_TIMELINE parameter for restore
• Added https://github.com/x4m/pg_tm_aux
• Added support of KUBERNETES_CACERT and other possible KUBERNETES_* environment variables.
• Compatibility with cgroup v2 when figuring out memory limit and auto-calculating shared_buffers size.
• wal-g v2.0.0
• timescaledb 2.7.0
• Patroni 2.1.4

Image: registry.opensource.zalan.do/acid/spilo-14:2.1-p6

• timescaledb 2.6.1
• Fixed build on non-privileged CI (https://github.com/zalando/spilo/pull/711)
• Added WALG_LIBSODIUM_KEY_TRANSFORM environment variable support (https://github.com/zalando/spilo/pull/706)
• Fixed permissions of runit files (https://github.com/zalando/spilo/pull/707)

Image: registry.opensource.zalan.do/acid/spilo-14:2.1-p5

• Patroni 2.1.3
• Timescaledb 2.5.2
• pg_cron 1.4
• Added an intermediate cron_admin role that allows to work with pg_cron jobs (previously only members of admin role were allowed to do that) (#699)
• Added wal-g proxy support (#661)
• Added support of AZURE_ENVIRONMENT_NAME (#688)
• Added support of SSH_PORT environment variable for wal-g (#676)
• Set AWS_S3_FORCE_PATH_STYLE for S3 compatible storage (#670)
• Implemented non-exclusive backups with wal-e (#686)
• Try to get IP from OpenStack EC2-compatible API (#684)
• Added first-last-agg, pgq_node, hll, dirtyread, and extra-window-functions extensions (#680, #689)

Image: registry.opensource.zalan.do/acid/spilo-14:2.1-p4

• Timescaledb 2.5.0 (including PostgreSQL 14 support)
• Added pglogical and pldebugger for PostgreSQL 14
• Added support for wal-g encryption environment variables (#649)

Image: registry.opensource.zalan.do/acid/spilo-14:2.1-p3

• Added PostgreSQL 14 and removed 9.5
• Timescaledb 2.4.2
• set_user 3.0.0

Image: registry.opensource.zalan.do/acid/spilo-14:2.1-p2

• Patroni 2.1.1
• wal-g 1.1 (#588)
• Timescaledb 2.4.1
• Certificate rotation based on file hashes, not modified time (#599)

Image: registry.opensource.zalan.do/acid/spilo-13:2.1-p1

• Timescaledb 2.2.1
• Make it possible to run cron without a root (#574)
• Fix clone_with_wale on PostgreSQL v13+ with recovery_time in future (#580)
• Add support for WAL-E/WAL-G with custom PGPORT (#582)

• Fixed bug with missing backend_type column in postgres_logs foreign table in PostgreSQL 13 (#573)
• Fixed postgres_backup.sh usage message (#572)
• Fixed test_reload_ssl.sh script, now it follows symlinks (#561)

Image: registry.opensource.zalan.do/acid/spilo-13:2.0-p6

• timescaledb 2.1.0 (including PostgreSQL 13 support) and 1.7.5
• Patroni 2.0.2
• Fixed a few issues with analyze after the major upgrade and promote.

Image: registry.opensource.zalan.do/acid/spilo-13:2.0-p5

• timescaledb 2.0.1
• wal-g 0.2.19, including WALG_SSH support
• Better OpenShift compatibility
• Reduced downtime during in-place major upgrade and a few bugfixes
• Automatically run analyze after promote
• Latest minor versions of PostgreSQL

Image: registry.opensource.zalan.do/acid/spilo-13:2.0-p4

• timescaledb 2.0
• postgis 3.1 for PostgreSQL 9.6 - 13
• A few little fixes around detecting environment and parsing cloud instance metadata

Image: registry.opensource.zalan.do/acid/spilo-13:2.0-p3

• Added PostgreSQL 13 (https://github.com/zalando/spilo/pull/520)
• Patroni 2.0.1
• Timescaledb 1.7.4
• Added pg_permission extension (https://github.com/zalando/spilo/pull/493, https://github.com/zalando/spilo/pull/504)
• Azure storage support (https://github.com/zalando/spilo/pull/514, https://github.com/zalando/spilo/pull/523)
• Support for additional locales (https://github.com/zalando/spilo/pull/513)
• Better support of OpenStack metadata (https://github.com/zalando/spilo/pull/486)
• Disabled wal-e/wal-g prefetch when restore_command is called for/from pg_rewind (https://github.com/zalando/spilo/pull/495)
• Use an IP address for Google instance metadata (https://github.com/zalando/spilo/pull/521)
• Added scripts for in-place major upgrade, see https://github.com/zalando/spilo/pull/488 for details.
• Changed the backup path to inlcude major version as a suffix: /spilo/{WAL_BUCKET_SCOPE_PREFIX}{SCOPE}{WAL_BUCKET_SCOPE_SUFFIX}/wal/{PGVERSION}. Backups made from the old Spilo or for the old major version should be cleaned manually.
• Automatically configure postgresql.bin_dir from the $PGDATA/PG_VERSION.

• Includes lates minor versions of PostgreSQL
• Added missing basebackup_fast_xlog section referenced from the standby_cluster (#435)
• Timescaledb 1.7.2 (#464)
• post_init.sh is executed with synchronous_commit=local (#440)
• Fix permissions of PGDATA on restart (#447)
• Added the pgaudit extension (#448)
• Added helper script for pgq which grants pgq_* roles to the admin role (#454)
• Removed pspg pager (#470)
• Enabled core dumps with shared memory filter (#475)
• Propagate AWS_REGION environment variable to wal-e/wal-g configuration (#478)
• Make sure certificates are owned by the postgres user (#479)

Image: registry.opensource.zalan.do/acid/spilo-12:1.6-p5

• Patroni 1.6.5
• Timescaledb 1.7.0 for PostgreSQL 12 (1.6.1 for older versions)
• pglogical for PostgreSQL 12
• Removed PostgreSQL 9.3 and 9.4
• Added possibility to run without root

Image: registry.opensource.zalan.do/acid/spilo-12:1.6-p3

• Patroni 1.6.4
• Added PostgreSQL 12
• Timescaledb 1.6.0
• wal-g 0.2.14
• Postgis 3.0 (and automatic upgrade)
• Supervisord replaced with lightweight runit
• Possibility to rotate PostgreSQL SSL certificates/keys
• IPv6 only compatibility
• Some fixes in wal-e configuration (sometimes it didn't work with new AWS regions)
• Default recovery window increased to 5 days
• The image is not compressed anymore and could work with read-only root fs (you still have to provide writable volume mounted as /run for configuration files)

Image: registry.opensource.zalan.do/acid/spilo-12:1.6-p2

• Patroni 1.6.0
• New postgres minor versions
• timescaledb 1.4.1
• wal-g 0.2.11
• wal-g is enabled by default for wal-fetch and backup-fetch when working with S3

Image: registry.opensource.zalan.do/acid/spilo-11:1.6-p1

• bump timescaledb version to 1.3.2
• disable timescaledb telemetry
• incorporate https://github.com/RafiaSabih/pg_auth_mon
• better support of non-AWS S3
• better handling of shared_preload_libraries in the pg_upgrade.py
• wal-g 0.2.9

Image: registry.opensource.zalan.do/acid/spilo-11:1.5-p9