We are very excited to announce a new release of the Postgres Operator in 2020! 🎄 🐘
This is the first release using the Spilo 13 image, incl. Patroni v2.0 and the newest PostgreSQL.
Please, read about the breaking changes when switching to PG13.
Update your CRDs to have manifest validation and field presevation up-to-date for newer Kubernetes versions (1.19+).
New features
- In-place major version upgrade (#1160, zalando/spilo#488)
- NodeAffinity support (#1166, #1263)
- pgBouncer support for replicas (#1159)
PostgresTeam
CRD to define custom team mappings (#1165)- Specify alternative scheduler (#1226)
- Inherited annotations for all major objects (#1236)
- Delete protection for Postgres manifests via annotations (#1069)
- Allow pod environment variables to be sourced from a secret (#946, #1177)
- Support wal-e backups to GCS (#620)
- Support migration to AWS gp3 volumes (#1242)
- Enable JSON logging (#1158)
Enhancements and fixes
- New
storage_resize_mode
option to resize volumes via updating PVCs (#958) ExternalTrafficPolicy
of services can now be configured (#1136)- Extend logical backup support to GCS (#1173)
- Set
search_path
for default roles inPreparedDatabases
(#1065) - Support
scram-sha-256
hash for password encryption (#995) - Include diffs on
securityContext
when clusters are synced (#1007, #1255) - Deletion of secrets on cluster deletion (#974, #1054, #1091)
- More flexibility when referencing an existing infrastructure roles secret (#1064, #1090)
- Improved visibility of events on failed cluster setups (#1013)
- Fixes and improvements on pgBouncer support (#960, #1169, #1171, #1213)
- Fixed configuring CRD via go-client (#1020, #1223)
- Fixed case where no
NodeReadinessLabel
is defined, but node isunscheduable
(#1162) - Fixed changing order of sidecar env variables (#980)
- Fixed syncing
PreparedSchemas
(#1139) - Fixed cloning from GCS (#1176)
- Make setup on OpenShift easier when using helm charts (#1037)
- Increase speed of e2e test and update kind version (#1180, #1185, #1121, #1156)
- UI: Now display cluster status if setup failed (#1260)
- UI: Add support for custom S3 endpoints (#1152)
- UI: Add
imagePullSecret
to deployment in helm chart (#1211) - UI: Add
Kustomization
manifest (#1086)
Breaking changes
- Manifest entries for
pg_hba
will overwrite the configuration and not append to it! - Variables in pod environment config map / secret will overwrite AWS/GCP setting in operator config (#1177)
- Enable
PGVERSION
env variable for Postgres 13 image (#1172, #1160, #1254, #1260) - Change default volume resize strategy to update PVCs instead of AWS API call (#1257)
- Migrate CRDs to apiVersion v1 (#746, #1212, #1228, #1248)
- Make
volume
section in Postgres manifest arequired
field (#1016) - Update to Go 1.15 (#1122, #1242)
- Switch public builds from Travis to GitHub Actions (#1215)
Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.6.0
UI Docker image: registry.opensource.zalan.do/acid/postgres-operator-ui:v1.6.0
Sample logical backup image: registry.opensource.zalan.do/acid/logical-backup:v1.6.0
Many thanks to the committers @Jan-M, @FxKu, @erthalion, @RafiaSabih, @sdudoladov
special thanks to @CyberDem0n for his continuous work on Patroni and Spilo,
and a loud applause to our external contributors @yanchenko-igor, @sagor999
@frittentheke, @Thunderbolt32, @spohner, @neelasha-09, @hlihhovac, @alfredw33,
@arminfelder, @bbsbb, @lxgege, @preved911, @dajudge, @lalbers, @hoangelos,
@programmer04, @Gottox, @mcoletti, @arichardet, @sonaysevik, @dalbani, @abh,
@SanjeevChoubey, @toonsevrin, @kupson