News for hackers. Stuff that matters.
Re:PostgreSQL 16 Released by olavgg on Thursday September 14, 2023 @09:38AM (#37508869)
Do I still have to use pg_upgrade when I'm just upgrading from RC-1?
Re:PostgreSQL 16 Released by jkatz05 on Thursday September 14, 2023 @10:09AM (#37509295)
git diff REL_16_RC1..REL_16_0 doesn't show any changes that would require a pg_upgrade (at least from my read), so you should be able to upgrade without it.
Re:PostgreSQL 16 Released by olavgg on Thursday September 14, 2023 @12:13PM (#37510853)
I just tested, I had to use pg_upgrade.

Error message: The database cluster was initialized with CATALOG_VERSION_NO 202306141, but the server was compiled with CATALOG_VERSION_NO 202307071.

Re:PostgreSQL 16 Released by yobert on Thursday September 14, 2023 @12:32PM (#37511157)
You might just need to run:

    alter database mystuff refresh collation version;