Postgres operator creates and manages PostgreSQL clusters running in Kubernetes
MIT License
Bot releases are hidden (Show)
We are excited to announce yet another new release of the Postgres Operator. Thanks to everyone who contributed with PRs, feedback, raising issues or providing ideas.
manual
mode) (#2729)additional_secret_mount_path
option when configured via config CRD (#2729)amd images:
Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.13.0
UI Docker image: registry.opensource.zalan.do/acid/postgres-operator-ui:v1.13.0
Logical Backup Docker image: registry.opensource.zalan.do/acid/logical-backup:v1.13.0
Multi-arch image (arm):
Postgres Operator: ghcr.io/zalando/postgres-operator:v1.13.0
UI: ghcr.io/zalando/postgres-operator-ui:v1.13.0
Logical Backup: ghcr.io/zalando/postgres-operator/logical-backup:v1.13.0
Default Spilo image: ghcr.io/zalando/spilo-16:3.3-p1
Thanks to our contributors: @idanovinda, @FxKu, @hughcapet, @macedigital, @sdudoladov
@fahedouch, @mbegenau, @nickmansrob, @desaintmartin
Published by FxKu 4 months ago
This is a bugfix release to the 1.12
version of the Postrges Operator. Thanks to everyone who gave feedback, raised issues or fixed bugs.
amd images:
Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.12.2
UI Docker image: registry.opensource.zalan.do/acid/postgres-operator-ui:v1.12.2
Logical Backup Docker image: registry.opensource.zalan.do/acid/logical-backup:v1.12.2
Multi-arch image (arm):
Postgres Operator: ghcr.io/zalando/postgres-operator:v1.12.2
UI: ghcr.io/zalando/postgres-operator-ui:v1.12.2
Logical Backup: ghcr.io/zalando/postgres-operator/logical-backup:v1.12.2
Default Spilo image: ghcr.io/zalando/spilo-16:3.2-p3
Thanks to our contributors: @macedigital, @FxKu, @idanovinda, @hemakshis, @Skoucail @crkochan
Published by FxKu 4 months ago
Please refer to the 1.12.2 changelog. The only difference is that we fixed the arm build pipeline for 1.12.2 and for helm charts, we only kept the last point release of each version.
Published by FxKu 5 months ago
We are excited to announce yet another new release of the Postgres Operator. Thanks to everyone who contributed with PRs, feedback, raising issues or providing ideas.
infrastructure_roles_secrets
config option (#2645)amd images:
Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.12.0-dirty
UI Docker image: registry.opensource.zalan.do/acid/postgres-operator-ui:v1.12.0
Logical Backup Docker image: registry.opensource.zalan.do/acid/logical-backup:v1.12.0
Multi-arch image (arm):
Postgres Operator: ghcr.io/zalando/postgres-operator:v1.12.0
UI: ghcr.io/zalando/postgres-operator-ui:v1.12.0
Logical Backup: ghcr.io/zalando/postgres-operator/logical-backup:v1.12.0
Default Spilo image: ghcr.io/zalando/spilo-16:3.2-p3
Thanks to our contributors: @FxKu, @idanovinda, @hughcapet
@dmotte, @LordGaav, @hemakshis, @duckhawk, @smutel, @ThoreKr, @pratheekrebala
Published by FxKu 7 months ago
We are excited to announce a new release of the Postgres Operator. Thanks to everyone who contributed with PRs, feedback, raising issues or providing ideas.
logical_backup_cronjob_environment_secret
(#2051)Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.11.0
Multi-arch image (arm): ghcr.io/zalando/postgres-operator:v1.11.0
UI Docker image: registry.opensource.zalan.do/acid/postgres-operator-ui:v1.11.0
Sample logical backup image: registry.opensource.zalan.do/acid/logical-backup:v1.11.0
Default Spilo image: ghcr.io/zalando/spilo-16:3.2-p2
Thanks to our contributors: @FxKu, @idanovinda, @Jan-M, @jopadi, @hughcapet, @sdudoladov, @macedigital,
@silenium-dev, @frittentheke, @b1zzu, @stgrace, @bootc, @cstohr1, @seekingua, @andrejshapal, @urashidmalik,
@capuche2412, @urashidmalik, @senthilnathan, @dgiebert, @tm604, @testwill, @dmotte, @ThoreKr, @Lukkie,
@drivebyer, @sklirg, @ghost, @MisguidedEmails, @ErikLundJensen, @boomskats @spreeker, @regme
Published by FxKu about 1 year ago
This is a bugfix release to the 1.10
version of the Postrges Operator. Thanks to everyone who gave feedback, raised issues or fixed bugs.
postgres-pod
for OpenShift (#2352)Prefix
with path /
(#2403)index.html
because it defaulted to localhost after #2195 (#2403)Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.10.1
UI Docker image: registry.opensource.zalan.do/acid/postgres-operator-ui:v1.10.1
Sample logical backup image: registry.opensource.zalan.do/acid/logical-backup:v1.10.1
Default Spilo image: ghcr.io/zalando/spilo-15:3.0-p1
Thanks to our contributors: @jopadi, @idanovinda, @hughcapet, @FxKu, @sdudoladov
@laiminhtrung1997, @cdmikechen, @k4kratik, @basaveswar-kureti,
@yoshihikoueno, @weeix, @pavanreddymaley, @edward2a, @wasap
Published by FxKu over 1 year ago
We are excited to announce a new release of the Postgres Operator. A rather small one but bringing you ARM support for the operator (pooler, ui and logical backup will follow). Thanks to everyone who contributed with PRs, feedback, raising issues or providing ideas.
syncStandby
as switchover candidate in synchronous mode (#2278)run_operator_locally
script (#2218)wal_level
config (#2245)KUBERNETES_SERVICE_HOST
as hostname and not only IP (#2285)RunAsUser
(100) and RunAsGroup
(101) in security context of pooler pods (#2255, #2225)failsafe_mode
option in OperatorConfiguration CRD to enable_patroni_failsafe_mode
(#2298)Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.10.0
Multi-arch image (arm-support): ghcr.io/zalando/postgres-operator:v1.10.0
UI Docker image: registry.opensource.zalan.do/acid/postgres-operator-ui:v1.10.0
Sample logical backup image: registry.opensource.zalan.do/acid/logical-backup:v1.10.0
Default Spilo image (arm-support): ghcr.io/zalando/spilo-15:3.0-p1
Thanks to our contributors: @FxKu, @hughcapet, @idanovinda, @jopadi, @sdudoladov, @Jan-M
@2tvenom, @LordGaav, @simo9000, @lengrongfu, @drivebyer, @genofire, @jgehrcke, @addreas,
@thcdrt, @jmehitch, @jfmatth, @thedatabaseme, @samox73, @yoshihikoueno, @verbotenj
Published by FxKu over 1 year ago
We are excited to announce a new release of the Postgres Operator. Thanks to everyone who contributed with PRs, feedback, raising issues or providing ideas. Expect another minor release soon with Patroni 3.0 support.
preferredDuringSchedulingIgnoredDuringExecution
(#2048, #2156)wal_level: logical
(#2034, #2109, #2187)mixed
storage resize mode was missing in CRD schema (#1947)policy/v1
and CronJob on batch/v1
dropped support for K8s 1.20 and lower (#2008, #2066)enable_readiness_probe: true
with pod_management_policy: parallel
[master|replica]_dns_name_format
now defaults to new template with namespace instead of team: "{cluster}.{namespace}.{hostedzone}"
(#2011)
[master|replica]_legacy_dns_name_format
when differing from the legacy "{cluster}.{team}.{hostedzone}"
default (#2171)-pooler
suffix in their DNS entries like "{cluster}-pooler.{team}.{hostedzone}"
(#2188)Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.9.0
UI Docker image: registry.opensource.zalan.do/acid/postgres-operator-ui:v1.9.0
Sample logical backup image: registry.opensource.zalan.do/acid/logical-backup:v1.9.0
Default Spilo image: ghcr.io/zalando/spilo-15:2.1-p9
Thanks to our contributors: @FxKu, @idanovinda, @jopadi, @hughcapet, @sdudoladov, @Jan-M
@dmvolod, @owenthereal, @francoispqt, @frittentheke, @orangetcy, @stgrace, @rocket357
@JBWatenbergScality, @machine424, @jeremie-seguin, @farodin91, @godzilla-s, @flyingcamilo,
@tamcore, @yoshihikoueno, @alfsch, @alexey-gavrilov-flant, @Pluggi, @thedatabaseme
@soluri, @Jaxwood, @dogaakcinar, @yajo, @stephan2012, @adriannieto-attechnest
Published by FxKu over 2 years ago
This is a very small bugfix release to the 1.8
version of the Postrges Operator. Thanks to everyone involved!
Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.8.2
UI Docker image: registry.opensource.zalan.do/acid/postgres-operator-ui:v1.8.2
Sample logical backup image: registry.opensource.zalan.do/acid/logical-backup:v1.8.2
Default Spilo image: registry.opensource.zalan.do/acid/spilo-14:2.1-p6
Thanks to our contributors: @FxKu, @idanovinda, @jopadi, @sdudoladov, @Jan-M, @CyberDem0n, @FactorT
Published by FxKu over 2 years ago
This is a bugfix release to the 1.8
version of the Postrges Operator. Thanks to everyone who gave feedback, raised issues or fixed bugs.
additional_owner_roles
are granted to database owners, not vice versa (operator will repair false membership) (#1869)uint64
type for fetching replication lag calling Patroni members endpoint (#1893)Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.8.1
UI Docker image: registry.opensource.zalan.do/acid/postgres-operator-ui:v1.8.1
Sample logical backup image: registry.opensource.zalan.do/acid/logical-backup:v1.8.1
Default Spilo image: registry.opensource.zalan.do/acid/spilo-14:2.1-p5
Thanks to our contributors: @FxKu, @idanovinda, @jopadi, @sdudoladov, @Jan-M, @CyberDem0n,
@dmvolod, @mujx, @stephan2012, @danlenar, @chitoku-k, @AllexVeldman, @rocket357
Published by FxKu over 2 years ago
We are excited to announce a new release of the Postgres Operator. Thanks to everyone who contributed with PRs, feedback, raising issues or providing ideas.
synchronous_node_count
option (#1484)IOPS
and throughput
options for volume settings (useful for AWS gp3 volumes) (#1824)ReadinessProbe
on the stateful set (#1825)LoadBalancer
, too (#943, #1799)nodeAffinities
(#1729)resources
in manifest will now pass validation with go-client (#1589, #1822)required
fields of cluster resources
from CRD schema. (#1822)required
fields of tolerations
from CRD schema (#1797)pod_environment_secret
(#1777)ServiceMonitor
(#1452)kubernetes_use_configmaps
is true
, do not try to create endpoints
(#1760)404 Not Found
(#1842)teamId
contains hyphens (#1859)pod_environment_secret
take precedence over pod_environment_configmap
(#1848)apiextensions.k8s.io/v1
(#1781)helm2
charts (#1679)v1.5.0.tgz
from helm chart folders (#1852)Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.8.0
UI Docker image: registry.opensource.zalan.do/acid/postgres-operator-ui:v1.8.0
Sample logical backup image: registry.opensource.zalan.do/acid/logical-backup:v1.8.0
Default Spilo image: registry.opensource.zalan.do/acid/spilo-14:2.1-p5
Thanks to our contributors: @FxKu, @jopadi, @sdudoladov, @Jan-M, @CyberDem0n,
@dmvolod, @machine424, @evsasha, @uzzz, @neelasha-09, @dpeckett, @Menzorg,
@stoewer, @jamesmcdonald, @Cellebyte, @jgillich, @preved911, @snarlysodboxer,
@ermajn, @Prototik, @moshloop, @spohner, @OlleLarsson, @Aisuko, @Lxrdknows77,
@Wikiwix, @Mattes83, @mujx, @RafiaSabih, @ebostijancic, @bleleve, @apeschel,
@sdressler, @kien-truong
Published by FxKu almost 3 years ago
This is a new minor release to the 1.7
version of the Postrges Operator. Thanks to everyone who gave feedback, raised issues or fixed bugs.
pending_restart
flag on later syncing (#1655)patroni
+ postgresql.parameters
manifest sections (#1635)Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.7.1
UI Docker image: registry.opensource.zalan.do/acid/postgres-operator-ui:v1.7.1
Sample logical backup image: registry.opensource.zalan.do/acid/logical-backup:v1.7.1
Default Spilo image: registry.opensource.zalan.do/acid/spilo-14:2.1-p3
Thanks to our contributors: @FxKu, @Jan-M, @CyberDem0n,
@Yajo, @elmehdisaniss, @wlritchi, @Lebvanih
Published by FxKu about 3 years ago
We are excited to announce a new release of the Postgres Operator.
values.yaml
file (#1224, #1603)Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.7.0
UI Docker image: registry.opensource.zalan.do/acid/postgres-operator-ui:v1.7.0
Sample logical backup image: registry.opensource.zalan.do/acid/logical-backup:v1.7.0
Default Spilo image: registry.opensource.zalan.do/acid/spilo-13:2.1-p1
Thanks to our contributors: @FxKu, @RafiaSabih, @sdudoladov, @Jan-M, @erthalion, @CyberDem0n,
@apeschel, @yanchenko-igor, @jcrood, @dalbani, @cucxabong, @frankconrad,
@flyinggecko, @golgoth31, @markus-codes, @yelhouti, @ssinger, @stromvirvel
Published by FxKu over 3 years ago
This is a new minor release to the 1.6
version of the Postrges Operator. Thanks to everyone who gave feedback, raised issues or fixed bugs.
targetContainers
is empty (#1475)spilo_runasuser
and spilo_runasgroup
from ConfigMap (#1503)Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.6.3
UI Docker image: registry.opensource.zalan.do/acid/postgres-operator-ui:v1.6.3
Sample logical backup image: registry.opensource.zalan.do/acid/logical-backup:v1.6.3
Default Spilo image: registry.opensource.zalan.do/acid/spilo-13:2.0-p7
Thanks to our contributors: @FxKu, @sdudoladov, @erthalion, @Jan-M, @CyberDem0n,
@cucxabong, @guicholeo
Published by FxKu over 3 years ago
This is a new minor release to the 1.6
version of the Postrges Operator. Thanks to everyone who gave feedback, raised issues or fixed bugs.
AllowPrivilegeEscalation
for pods (true
by default) (#1412, #1433)additional_pod_capabilities
(#1380)Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.6.2
UI Docker image: registry.opensource.zalan.do/acid/postgres-operator-ui:v1.6.2
Sample logical backup image: registry.opensource.zalan.do/acid/logical-backup:v1.6.2
Default Spilo image: registry.opensource.zalan.do/acid/spilo-13:2.0-p6
Thanks to our contributors: @Jan-M, @FxKu, @erthalion, @sdudoladov, @CyberDem0n,
@machine424, @neelasha-09, @caiconkhicon, @holyhope, @ssinger
Published by FxKu over 3 years ago
This is a new minor release to the 1.6
version of the Postrges Operator. Thanks to everyone who gave feedback, raised issues or fixed bugs.
⚠️ Note, this release contains a bug which leads to rolling updates on each SYNC event. You have to either configure additional_pod_capabilities
(e.g. SYS_NICE
what is beneficial for Spilo) to something what is allowed in your environment or keep on using the v1.6.0
.
spilo_runasuser
and spilo_runasgroup
being ignored (#1361)AllowPrivilegeEscalation
based on spilo_privileged
setting (#1326, #1328)Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.6.1
UI Docker image: registry.opensource.zalan.do/acid/postgres-operator-ui:v1.6.1
Sample logical backup image: registry.opensource.zalan.do/acid/logical-backup:v1.6.1
Default Spilo image: registry.opensource.zalan.do/acid/spilo-13:2.0-p4
Thanks to our contributors: @Jan-M, @FxKu, @sdudoladov, @RafiaSabih, @erthalion, @CyberDem0n,
@tommasopozzetti, @batazor, @mseiwald, @apeschel, @georgebarbarosie @zvier, @balibebas,
@dervoeti, @sagor999, @polarclair
Published by FxKu almost 4 years ago
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+).
PostgresTeam
CRD to define custom team mappings (#1165)storage_resize_mode
option to resize volumes via updating PVCs (#958)ExternalTrafficPolicy
of services can now be configured (#1136)search_path
for default roles in PreparedDatabases
(#1065)scram-sha-256
hash for password encryption (#995)securityContext
when clusters are synced (#1007, #1255)NodeReadinessLabel
is defined, but node is unscheduable
(#1162)PreparedSchemas
(#1139)imagePullSecret
to deployment in helm chart (#1211)Kustomization
manifest (#1086)pg_hba
will overwrite the configuration and not append to it!PGVERSION
env variable for Postgres 13 image (#1172, #1160, #1254, #1260)volume
section in Postgres manifest a required
field (#1016)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
Published by FxKu over 4 years ago
We are excited to announce yet another release of the Postgres Operator. It's a big one! 🐘
postgres-operator
cluster role (deployments
and events
added) (#799, #952)ClusterLabels
as JSON to Spilo (#877)Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.5.0
UI Docker image: registry.opensource.zalan.do/acid/postgres-operator-ui:v1.5.0-dirty
Sample logical backup image: registry.opensource.zalan.do/acid/logical-backup:master-58
Connection pooler image: registry.opensource.zalan.do/acid/pgbouncer:master-7
Shipped with latest Patroni v1.6.5 and Spilo 12:1.6-p3 releases
Many thanks to the committers @erthalion, @FxKu, @sdudoladov, @RafiaSabih, @Jan-M,
special thanks to @CyberDem0n for his continuous work on Patroni and Spilo,
and kudos to our external contributors @ReSearchITEng, @seuf, @zimbatm, @fischerman,
@frittentheke, @lalbers, @Prototik, @siku4, @f2cognite, @PetrBarborka, @marcusportmann,
@hengchu, @grantlanglois, @hzliangbin, Jonher937, @boopathykpm
Published by FxKu over 4 years ago
We are happy to announce yet another release of the Postgres Operator 🐘
We have also updated the UI and improved its setup and documentation to make local testing easier:
logical_backup_s3_region
(#813)min_instances
is set higher (#797, #842)MasterPodMoveTimeout
(#816)postgresql-client-12
(#813)postgres-pod
dedicated for database pods and Patroni (#832)rbac.authorization.k8s.io
to v1. Update pod_service_account_role_binding_definition
configuration if you are using it. (#829)cluster-name
as default for cluster name label everywhere (#782)Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.4.0
UI Docker image: registry.opensource.zalan.do/acid/postgres-operator-ui:v1.4.0
Sample logical backup image: registry.opensource.zalan.do/acid/logical-backup
Shipped with Patroni v1.6.4 and Spilo 1.6-p2
Many thanks to the committers @FxKu, @Jan-M, @erthalion, @RafiaSabih, @sdudoladov, @hjacobs,
special thanks to @CyberDem0n for his continuous work on Patroni and Spilo,
and applause to our contributors @jonathanbeber, @siku4, @vitobotta, @f2cognite
Published by FxKu almost 5 years ago
This is new minor release which simply bumps the version, as the v1.3.0 did not reflect the latest state from master. Copyright and licence are updated to 2020.
Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.3.1
Sample logical backup image: registry.opensource.zalan.do/acid/logical-backup:master-57
The Postgres Operator UI image remains unchanged.