This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

In-place Upgrade to Postgres 16

Posted on 06-19-2024 04:15 AM
kataklinger
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

Hey!

CloudSQL release notes states that it is not possible to do in-place upgrade from a previous version of Postgress to the version 16. Are there any plans to support this upgrade path(specifically from version 15) at some point? Thanks.

Regards.

0 2 624
Topic Labels
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
kshenoy
Staff
Reply posted on --/--/---- --:-- AM

Major version upgrades to PostgreSQL 16 will be supported in future, but we do not an ETA yet. Will keep you posted on this forum. 

Posted on --/--/---- --:-- AM
dataspun
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Major version upgrade to PostgreSQL 16 repeatedly fails without any error in the logs.  None of the known limitations apply.  The operation fails with  "major version upgrade failed, please look at postgres-upgrade.log for more details and follow the instruction on user guide" -- however the upgrade log doesn't offer any details on the failure.

UPDATE: after combing through the upgrade log I see errors being output from pg_restore operations.  One confusing aspect is that the Log Explorer item doesn't indicate any Error severity, only the Informational icon.  Also, every database in the instance appears to have at least one giant entry in the log per Upgrade attempt.  So if your instance happens to have a lot of databases, understanding why the Upgrade attempt failed can be quite the slog.  Lastly, the errors output by pg_restore can be quite numerous and involve issues with PostGIS and other dependencies that are currently undocumented.  It seems that Cloud SQL has sufficient information at hand to indicate why an Upgrade attempt failed, perhaps even to summarize which actions could be taken to resolve.   

0 Likes