SQL-Ledger and PostgreSQL versions

B

bgroper

I try to use pkg's wherever possible. Usually fast and mostly frictionless.
SQL-Ledger pkg requires postgresql17-server, BUT the "default" version for postgres server is 16.
It all seems to work nicely with postgres17, but does is type of minor conflict expected to occur often ?
Do I just need to get used to fiddling amongst versions of different packages ?
Yes, I do realise more experienced users will say to do everything with ports, but that takes time that I'd rather spend on IRL issues.
TIA's for all tips and clues.
 
Default version of PGSQL is 17 from 20250506 and it's in pkg quarterly repo in 14.3-RELEASE.

20250506:
AFFECTS: users of databases/postgresql* and other software using PostgreSQL to run
AUTHOR: *********

The default version of PostgreSQL has been switched from 16 to 17.
The upgrade procedure can use up twice the space the databases
currently needs. If you have a big amount of stored data take a
closer look at the manpage of pg_upgrade for avoidance and/or
speedup of the upgrade.
Click to expand...

PORTNAME= sql-ledger
Click to expand...
BUILD_DEPENDS= p5-DBD-Pg>=0:databases/p5-DBD-Pg
USES= apache:run perl5 pgsql shebangfix
Click to expand...
 
% cat /usr/ports/Mk/bsd.default-versions.mk| grep PGSQL_DEFAULT
PGSQL_DEFAULT?= 17

Sorry, I missed that recent change to critical detail.
 
It depend to which GitHub branch of the port tree you are syncing. I usually pull the "main" branch which is used in "Latest" repo of pkg but default pkg repo is "quarterly" which currently is 2025Q3 branch in GitHub so if you are using quarterly it's better to look up the UPDATING file in that given branch in git.

Main:
https://github.com/freebsd/freebsd-ports/blob/main/UPDATING
https://github.com/freebsd/freebsd-ports/blob/main/Mk/bsd.default-versions.mk

2025Q3:
https://github.com/freebsd/freebsd-ports/blob/2025Q3/UPDATING
https://github.com/freebsd/freebsd-ports/blob/2025Q3/Mk/bsd.default-versions.mk
 
You must log in or register to reply here.
Back
Top