Postgres 14.4 on Solaris 11 unsupported in v6 and v7?

[lodewijk]

After (finally) upgrading my postgres version to 14.4 for Photo Supreme v5 running on a dedicated Solaris 11.3 server, I'm running into a dead end.
v6 and v7 both complain that my Postgres version (PostgreSQL 14.4 on i386-pc-solaris2.11, compiled by gcc (GCC) 4.8.2, 64-bit) is not supported.

Is there a way to bypass this check? I have compiled Postgres 14.4 from the source code, without errors, and I really would like to benefit from the data protection ZFS provides for my images.

[Hert]

V6 runs with PostgreSQL 9 to PostgreSQL 13.
V7 runs with PostgreSQL 12 to PostgreSQL 14

What result are you getting when you run this query?

Code: Select all

select version()

[lodewijk]

postgres=# select version();
version
-----------------------------------------------------------------------------
PostgreSQL 14.4 on i386-pc-solaris2.11, compiled by gcc (GCC) 4.8.2, 64-bit
(1 row)

[Hert]

That should work with PSU V7 (V6 supports up to PG13, so you cannot run PSU6 with PG14).

Can you share a V7 screenshot that states that your version is not suppoted?

[lodewijk]

Can I upgrade from v5 to v7 directly? I was working under the assumption that I needed to go to v6 first in order to preserve the database upgrade.

[Hert]

You can skip V6. V7 also upgrades a V5 database.

[lodewijk]

Success, thanks for the guidance.

For completeness, those compiling postgres themselves should also compile and install dblink in the contrib directory.

[Hert]

Great, and that's a good tip