Question about postgresql*-server packages...

[B.C. Cotman]

Hello fellow list members,

Last year around September or October, I was testing out Hardened BSD
14 before it was moved to become Hardened BSD 14 stable, and there was
a package for postgresql server. IIRC, several were available as
packages like:

postgresql15-server

postgresql14-server

postgresql13-server

Recently, I built a new Hardened BSD 14 stable, and searched packages,
but do not see any of the PostgresSQL Server packages for any version,
but I do see the postgresql client, contrib and docs packages which
the server depends upon.

As a test, on a test Hardened BSD 14 server, I tried the path of
building Postgresql-16 server from ports, and found several newer
versions of installed packages were needed including a suite of newer
python 3.9 packages from ports and the newer ports version of rust and
more.

Are the PostgreSQL server packages not available due to a collection
of dependencies not yet solidified for Hardened BSD 14?

Is there an estimate for when there will be postgres server packages
available again?

This is not an urgent request: take your time.

Thanks!

[B.C. Cotman]

For anyone else interested, I revisited this and found a simple work-around...

Don't rely on ports with auto-dependencies to build required packages
for postgresq16-server

Install all pkg deps required to build postgresql16-server from ports.

Build of ports-based "postgresql16-server": build worked, installed,
init-ed db, and ran after being configured.

I'm able to test a new service against postgres*-server on Hardened BSD 14. Yey!

Any idea when the pkg repo will again have the postgresql*-server*
packages available?

Examples of what I am typing about:

When I:
"pkg update && pkg search postgresql | grep '[0-9]-server'
(No server packages shown)

When I:
"pkg update && pkg search postgresql | grep '[0-9]-client'"
(Client packages found)
postgresql11-client-11.21 PostgreSQL database (client)
postgresql12-client-12.16 PostgreSQL database (client)
postgresql13-client-13.12 PostgreSQL database (client)
postgresql14-client-14.9 PostgreSQL database (client)
postgresql15-client-15.4 PostgreSQL database (client)
postgresql16-client-16.0 PostgreSQL database (client)

After ports build of postgresql16-server:
pkg info | grep '[0-9]-server'
(the ports package I built shows up as installed)
postgresql16-server-16.1_3 PostgreSQL is the most advanced
open-source database available anywhere

Still no rush. Good luck in 2024 everyone!

[Shawn Webb]

Hey there!

Sorry for the delayed response. Dealing with health issues this week.
The 14-stable package build was delayed a bit in pretty much all of
December due to my dad coming down to help us with the new house. I
didn't want to start a package build just to power off the equipment
mid-build to increase power capacity to the server room.

In December, I had fixed the postgresql*-server ports, but since the
package build was delayed, there's still no related packages.

A new build is going on right now. You can monitor it here:
https://hbsd-pkg-14-stable-01.hardenedbsd.org/build.html?mastername=hbsd14-default&build=2024-01-01_10h53m34s

I'll let you know when the repo is synced. The various postgresql*
ports should be included in this build.

Thanks,

--
Shawn Webb
Cofounder / Security Engineer
HardenedBSD

https://git.hardenedbsd.org/hardenedbsd/pubkeys/-/raw/master/Shawn_Webb/03A4CBEBB82EA5A67D9F3853FF2E67A277F8E1FA.pub.asc