Is there somewhere I can help?

[Cromulent]

First of all I'm a newbie so don't expect much. I use PostgreSQL for my database. I have PostgreSQL 16.1 installed on my FreeBSD 14.0 virtual server but the PostGIS package pulls in PostgreSQL 15.5 instead. I'd like to get it to the stage where I can use it with the 16.1 version of PostgreSQL.

I've compiled software in the past but not on FreeBSD so I'm not familiar with the standard way of doing things. What would your suggestion be?

 

[drhowarddrfine]

Read the Handbook

 

[YYY__]

PostGIS only supports PostgreSQL 15 even though PostgreSQL 16 is available

It seems that PostGIS 3.3.4 (which is the latest version I could find) requires PostgreSQL 15 but I'm using PostgreSQL 16 which is the latest version available via the package manager. Is there a plan to update it to use PostgreSQL 16? Also on the same subject the PostgreSQL 16 package is only...

forums.FreeBSD.org

Isn't it somehow answered there?

 

[SirDice]

but the PostGIS package pulls in PostgreSQL 15.5 instead.

Ports generally pull in a 'default' version, so they only have indicate they want to use a PostgreSQL client.

Those defaults are set in /usr/ports/Mk/bsd.default-versions.mk.

# Possible values: 12, 13, 14, 15, 16
PGSQL_DEFAULT?=		15

bsd.default-versions.mk « Mk - ports - FreeBSD ports tree

cgit.freebsd.org

The packages in the FreeBSD repository are always built with those defaults. If you build from ports or build your own repository you can change those defaults. You could set DEFAULT_VERSIONS+= pgsql=16 for example, to have everything depend on PostgreSQL 16.

 

[Cromulent]

Thank you very much.