zalando / postgres-operator

Postgres operator creates and manages PostgreSQL clusters running in Kubernetes
https://postgres-operator.readthedocs.io/
MIT License
4.35k stars 980 forks source link

major upgrade / WAL Archiving #1651

Open itmwiw opened 3 years ago

itmwiw commented 3 years ago

Hello,

When trying to do an Inplace major upgrade from Postgres 12 to Postgres 13, I had an issue the upgrade. When viewing the logs, it was saying that it failed to stop the server. After some searching it was due to WAL archiving: Once I disabled the WAL archiving, the upgrade went fine. So my question is: Did I misconfigured something from my side, or is it something that can't be automatized for now (automatically disable the wal archiving, doing the upgrade and then restarting the wal archiving)? Thanks in advance

FxKu commented 3 years ago

Hm, no this should all be done by the inplace-upgrade.sh script. Creating a CHECKPOINT, stopping Postgres etc. Maybe you can provide some logs of Patroni (pod logs) and Postgres (although these are cycled each week).