Should add the postgres contrib package as well so when aox installer
tries to add citext, it doesn't bomb.
On 2014/10/16 17:51, Mark Felder wrote:
On Thu, Oct 16, 2014, at 16:26, james wrote:
Mark,
Is there a particular reason why the port (or rather, what is in the pkg
repo for FreeBSD 9.3) is dependent on postgresql 9.2?
It does seem annoying that the server package depends on the client
package, and the result is that after rebuilding my nas and mail box and
going with straight packages, that I'm back on postgresql 9.2.
FreeBSD does not yet have a PROVIDES mechanism so you can perhaps say
Postgres 9.1, 9.2, 9.3, or 9.4 can "PROVIDE" the "POSTGRESQL-SERVER"
role. As a result, packages a dependent on specific versions at build
time. As of right now FreeBSD's "default" version of Postgres is 9.2. If
you have access to a ports tree still you'll find the default versions
for different software in the following file:
/usr/ports/Mk/bsd.defaults.mk
Postgres is 9.2, as I said previously:
PGSQL_DEFAULT?= 9.2
The only way to override this is to build your own package repository
with poudriere, or use ports. Frustrating, I know. I had to run 8
different package repositories at work to provide sane defaults for
different FreeBSD environments. There is ongoing work to fix this. I
have no clue what the ETA is, but this is not being ignored. It just
takes a lot of work to fix the ports tree infrastructure to understand
modern packaging conventions. The ports tree is very powerful, but was
not originally intended for people to consume it from packages.
For the record, the archiveopteryx port is configured to require
Postgres 9.1 or newer, as it simply won't work at all with anything
older:
WANT_PGSQL_VER= 91+
If you want to still use packages you can very easily prop up your own
package repository. I have a simple guide on my blog[1] which should
still be accurate. You'd just want to set in your
/usr/local/etc/poudriere.d/make.conf :
DEFAULT_VERSIONS= pgsql=9.3
and then build your archiveopteryx and other ports into packages.
Hope this helps...
[1] http://blog.feld.me/posts/2014/06/freebsd-poudriere-cheat-sheet/