coinstallable version of pgsql (POC)

Baptiste Daroussin bapt at
Fri May 6 23:35:16 UTC 2016

Hi all,

Apparently noone had time to work on making all the version of pgsql
coinstallable since we last talked about it

Here is a proof of concept done on pg95 which makes it coinstallable:

It is unfinished given I have not enough time for that.

Basically it keeps the package split as it is now (PoC done on clients, server,
contrib and plperl) for server what remains is renaming the rc.d script

all binaries are now installed under lib/postgresql95/bin and a symlink in
regular bin suffixed by the version number.

the rpath from the default built is disabled and replaced with a new one which
ensure the order of the rpath is correct (the default one is not in the right
order) which ensure the libpq version found in priority is the the right
version. using rpath is good here to avoid adding a ldconfig file which would
make other programs accidentally find the non default libpq

In order to keep the manpages, in category 1 the manpages have been renamed to
match the name of the symlinks in the PATH

In the 7 category thet have been suffixed with postgresql${version} so one can
really have all the manpages for all clients available and clearly state which
one correspond to which version

the man3 and pkgconfig has been removed as they belong to the libpq package

What is missing: create a new postgresql-libq based on latest pg version which
is installed in the default lib directory

What I forgot here is to add a BUNDLE_LIBS=yes for the solver never to take in
accoung from those clients

Last thing would be to cleanup Mk/Uses/ to allow parallel installation

I really hope you like that approach and that someone will be able to finish it

That would be really helpful for users to be able to decide which version of pg
they want without having to build their own packages.

It will also simplify upgrading as at one point one have tools from all version
of postgresql available at once.

Best regards,
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: not available
URL: <>

More information about the freebsd-ports mailing list