Embed Notice

@Phobos @HatkeshiatorTND @lain @Sternritter-C Postgres will happily nuke your database if you upgrade to a newer major version without dump/restoring it or going through pg_upgrade.

The warning on the wiki is there for a reason and there's a reason why most distros shipping multiple version have some script to automate upgrading between major versions.

And fixing such damaged database while not impossible requires deep understating of how Postgres internally stores data. It's not as simple as "oops, I updated Postgres without pg_upgrade and restarted it already. I'll just downgrade and restart it again."