Bug 245958 - databases/pg_citus: Fails to build with PostgreSQL 10 2020Q2
Summary: databases/pg_citus: Fails to build with PostgreSQL 10 2020Q2
Status: Closed FIXED
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: amd64 Any
: --- Affects Some People
Assignee: Matthew Seaman
URL:
Keywords: needs-qa
Depends on:
Blocks:
 
Reported: 2020-04-27 08:18 UTC by rainer
Modified: 2020-04-27 20:52 UTC (History)
0 users

See Also:
bugzilla: maintainer-feedback? (matthew)
koobs: merge-quarterly?


Attachments
poudriere build log (17.67 KB, text/plain)
2020-04-27 08:18 UTC, rainer
no flags Details

Note You need to log in before you can comment on or make changes to this bug.
Description rainer 2020-04-27 08:18:27 UTC
Created attachment 213838 [details]
poudriere build log

FreeBSD 12.1 amd64.
poudriere 3.3.4

DEFAULT_VERSIONS+=mysql=10.2m apache=2.4 ruby=2.5 pgsql=10 perl5=5.28

Makefile says 
USES=           compiler:c11 gmake pgsql:10+ autoreconf readline


I think it needs pgsql 11.

https://repos.citusdata.com/community/
Comment 1 Kubilay Kocak freebsd_committer freebsd_triage 2020-04-27 08:34:05 UTC
Thank you for the report Rainer.

Does databases/pg_citus build with postgresql10 in the Latest branch?

If so, can you identify any commits that resolved the issue or introduced that support?
Comment 2 rainer 2020-04-27 09:44:55 UTC
If you look at their repository, they only provide binaries for pgsql11 and pgsql12.

So I think it only builds with 11 and 12.
The configure script fails when it only finds postgresql10 libs.

I must admit I do not use it (yet), it's just part of my package-build as an "interesting" package.

I realized that it's not part of my "experimental" package build which has postgres12 as default.
Comment 3 Matthew Seaman freebsd_committer freebsd_triage 2020-04-27 10:49:38 UTC
Ack. I'll verify that the version requirements have changed upstream and update the port accordingly today.

Thank you for the report.
Comment 4 Matthew Seaman freebsd_committer freebsd_triage 2020-04-27 11:00:09 UTC
Hmmm... FAQ states pg_citus 8.x is compatible with 10 or 11.  (https://www.citusdata.com/faq)

Hasn't been updated for pg_citus 9.x, but I think they seem to have a policy of only supporting the last two release versions of postgres, or in other words, PG 11 or 12 at the moment.
Comment 5 commit-hook freebsd_committer freebsd_triage 2020-04-27 20:51:39 UTC
A commit references this bug:

Author: matthew
Date: Mon Apr 27 20:51:19 UTC 2020
New revision: 533169
URL: https://svnweb.freebsd.org/changeset/ports/533169

Log:
  Mark the port as requiring postgresql-11 or higher.  Attempting to
  build the port with postgres-10 results in:

  ```
  configure: error: Citus is not compatible with the detected PostgreSQL version 10.
  ```

  No PORTREVISION bump, as this will have no effect on the default
  packages (which link against postgresql-11) or on anyone who has
  successfully built pg_citus.  All that happens is that we detect the
  incompatible postgresql version earlier in the build process and error
  out sooner.

  PR:		245958
  Reported by:	rainer@ultra-secure.de

Changes:
  head/databases/pg_citus/Makefile
Comment 6 Matthew Seaman freebsd_committer freebsd_triage 2020-04-27 20:52:09 UTC
committed, thanks!