3 ms·

I'd like to see easier upgrades between major versions, or at least published docker images that can do the upgrade. As it stands, it's a huge hassle to get bot

I'd like to see easier upgrades between major versions, or at least published docker images that can do the upgrade. As it stands, it's a huge hassle to get both binaries installed on the same system. This is a task almost everyone has to do periodically, it should be easier.

doctor_eval 4y ago
Yes this is a huge problem. I wish PG could contain whatever it needs to do in place upgrades from supported versions. Statically compiled builds of previous versions of pg_upgrade?
ncrmro 4y ago
In Kubernetes a service call end an operator watches for CRD specifying databases to be created and manages upgrade and backs for those databases. https://github.com/zalando/postgres-operator https://github.com/zalando/postgres-operator
zX41ZdbW 4y ago
I also found it strange that PostgreSQL cannot simply support data formats of previous versions. In contrast, the latest version of ClickHouse[1] (23.1) can be installed over the version from 2016, and it does not require format conversions or any other migration procedures. [1] https://github.com/ClickHouse/ClickHouse/ https://github.com/ClickHouse/ClickHouse/