Comments (4)
Hi @mzwettler2!
There is a note about this in the Components & Compatibility docs:
The latest two major versions of Postgres are available through the Crunchy Developer Program. The Postgres upgrade container includes one prior version of Postgres to facilitate major Postgres version upgrades.
Hope this helps!
from postgres-operator.
there is a new postgres version every year that is supported by the community for 5 years.
according to your statement, the pgupgrade container always contains the last two Postgres versions, currently 15+16.
how can I do a physical upgrade from an older Postgres version, e.g. from version 13 to 16?
from postgres-operator.
Hi @mzwettler2!
To clarify, the Postgres upgrade image contains one additional Postgres version, in addition to the two that are currently maintained via the Crunchy Developer Program (as specified on the Supported Platforms page). For instance, the latest upgrade container for the CPK v5.5.1
release (crunchy-upgrade:ubi8-5.5.1-0
) includes Postgres 14, 15 and 16.
Considering you’re currently on Postgres 13, that means you should be able to simply leverage a recent version of CPK (specifically one that included support for Postgres 13) to upgrade to one of the two currently maintained versions of Postgres. For instance, considering CPK v5.4.1
was the last/latest Developer Program release of CPK with support for Postgres 13, you can use the included crunchy-upgrade:ubi8-5.4.1-0
image to get to Postgres 15 (which is one of the two version of Postgres currently being maintained via the Developer Program). And from there you can quickly/easily upgrade CPK to the latest version available (currently v5.5.1
), which will then enable your to upgrade Postgres to version 16.
And moving forward, in addition to simply leveraging the Supported Platforms page to see the versions of Postgres currently supported via the Crunchy Developer Program, I also recommend signing up for the Developer Program mailing list via the link below. This will ensure you receive the latest updates and announcements about to Postgres container availability, e.g. in order to keep your cluster’s images up-to-date:
https://www.crunchydata.com/developers/download-postgres/containers
from postgres-operator.
Thanks for clarification.
Wouldn't it make sense to always include the last 5 Postgres major versions in the current pgupgrade image, since every Postgres major version is supported for 5 years (also true for CPK if one is having a subscription).
from postgres-operator.
Related Issues (20)
- How to set ulimit (stack size) with a larger value HOT 2
- registry.developers.crunchydata.com not availible anymore.. HOT 2
- how to create groups or run SQL files using crunchy postgres operator yaml without deleting the Postgres cluster HOT 1
- Basic Steps/Tutorial On how to use the Operator? HOT 3
- 5.5.1 broken upgrade HOT 2
- Documentation Bug - Missing Key HOT 2
- Create Openshift Service + Route on PGAdmin resource deployment HOT 1
- Recreate pgbackrest stanza after lost backrest-shared-repo storage, please help! HOT 2
- Postgres replicas bootstrap error at new deployment HOT 2
- How to enable debug mode in postgres HOT 4
- closed HOT 3
- Adding extension mysql_fdw to postgres-gis HOT 2
- How to limit or prevent the impact HOT 3
- pgbackrest backup fails with ERROR: [082]: WAL segment 000001B000000AF80000009B was not archived before the 60000ms timeout HOT 2
- Issue with the makefile
- Default requests/limits for containers in PostgresCluster CR HOT 3
- Deploying replication slots HOT 1
- Postgres Major Version Upgrade connection to server on socket "/pgdata/.s.PGSQL.50432" failed: FATAL: could not access file "zombodb.so": No such file or directory HOT 2
- UnableToCreateStanzas warning with wrong address for backup repo pod
- Add the postgrescluster helm chart to the OCI developer registry
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from postgres-operator.