Postgres 14.4 on Solaris 11 unsupported in v6 and v7?

Post Reply
lodewijk
Posts: 11
Joined: 16 Jul 16 7:29

Postgres 14.4 on Solaris 11 unsupported in v6 and v7?

Post by 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
Posts: 7314
Joined: 13 Sep 03 6:24

Re: Postgres 14.4 on Solaris 11 unsupported in v6 and v7?

Post by 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()
This is a user-to-user forum. If you need product support then please send a message
lodewijk
Posts: 11
Joined: 16 Jul 16 7:29

Re: Postgres 14.4 on Solaris 11 unsupported in v6 and v7?

Post by 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
Posts: 7314
Joined: 13 Sep 03 6:24

Re: Postgres 14.4 on Solaris 11 unsupported in v6 and v7?

Post by 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?
This is a user-to-user forum. If you need product support then please send a message
lodewijk
Posts: 11
Joined: 16 Jul 16 7:29

Re: Postgres 14.4 on Solaris 11 unsupported in v6 and v7?

Post by 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
Posts: 7314
Joined: 13 Sep 03 6:24

Re: Postgres 14.4 on Solaris 11 unsupported in v6 and v7?

Post by Hert »

You can skip V6. V7 also upgrades a V5 database.
This is a user-to-user forum. If you need product support then please send a message
lodewijk
Posts: 11
Joined: 16 Jul 16 7:29

Re: Postgres 14.4 on Solaris 11 unsupported in v6 and v7?

Post by lodewijk »

Success, thanks for the guidance.

For completeness, those compiling postgres themselves should also compile and install dblink in the contrib directory.
Hert
Posts: 7314
Joined: 13 Sep 03 6:24

Re: Postgres 14.4 on Solaris 11 unsupported in v6 and v7?

Post by Hert »

Great, and that's a good tip
This is a user-to-user forum. If you need product support then please send a message
Post Reply