Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!

Bug 392673

Summary: dev-db/postgresql-base does not have a python support
Product: Gentoo Linux Reporter: Guillaume Ayoub <guillaume>
Component: Current packagesAssignee: PgSQL Bugs <pgsql-bugs>
Status: RESOLVED FIXED    
Severity: minor CC: ronan
Priority: Normal    
Version: unspecified   
Hardware: All   
OS: Linux   
Whiteboard:
Package list:
Runtime testing required: ---
Attachments: Unify configuration of postgresql-base and postgresql-server

Description Guillaume Ayoub 2011-11-30 20:02:42 UTC
postgresql-base is compiled with --without-python, set in the ebuild. Adding a "python" USE flag can set the --with-ptyhon flag, installing some files needed to build python-based PostgreSQL extensions.

Reproducible: Always
Comment 1 Aaron W. Swenson gentoo-dev 2011-12-01 01:32:39 UTC
What are the PostgreSQL extensions?
Comment 2 Guillaume Ayoub 2011-12-01 08:27:22 UTC
Multicorn, for example (http://multicorn.org/), needs a Makefile that is only installed if postgresql-base is compiled --with-python.
Comment 3 Aaron W. Swenson gentoo-dev 2011-12-03 16:00:16 UTC
Foreign Data Wrappers, like Multicorn, require the executor and planner found in dev-db/postgresql-server which can have Python support enabled there.
Comment 4 Guillaume Ayoub 2011-12-03 20:50:46 UTC
The compilation of Multicorn needs to find the python flags set in /usr/lib/postgresql-9.1/lib/pgxs/src/Makefile.global, which is installed by postgresql-base (not by postgresql-server). The --with-python flag of postgresql-base sets these flags in Makefile.global.
Comment 5 Ronan Dunklau 2012-12-11 13:14:08 UTC
Sorry to resurrect an old bug, but I think the pg_config utility, as well as the generated Makefiles, need to be in sync with the postgresql server.

This is not the case right now, since different options can be used in the configure script from one and the other.

It is obvious with this case of "--without-python" hardwritten in the postgresql-base ebuild.

The whole postgresql extension system (PGXS) is built around the pg_config utility, and the various generated Makefiles, and as such I think it is very important to keep them in sync.

Could you please reconsider reopening/fixing this bug ?
Comment 6 Patrick Lauer gentoo-dev 2013-05-16 08:50:46 UTC
Looks like a valid bugreport to me ...
Comment 7 Ronan Dunklau 2013-06-26 08:41:35 UTC
Created attachment 351990 [details, diff]
Unify configuration of postgresql-base and postgresql-server

Please find attached a patch which uses the same configuration for building postgresql-base and postgresql-server.

In addition to that, postgresql-server also install the pg_regress utility which can be useful for extension developer.
Comment 8 Aaron W. Swenson gentoo-dev 2013-06-26 14:01:57 UTC
(In reply to Ronan Dunklau from comment #7)
> Created attachment 351990 [details, diff] [details, diff]
> Unify configuration of postgresql-base and postgresql-server
> 
> Please find attached a patch which uses the same configuration for building
> postgresql-base and postgresql-server.
> 
> In addition to that, postgresql-server also install the pg_regress utility
> which can be useful for extension developer.

Thank you for your eagerness, but it is incomplete. Further, hijacking a bug for a separate issue is not okay.

Please see my work-in-progress:
https://github.com/titanofold/titanofold-gentoo-x86/tree/master/dev-db/postgresql

I'm actively working on several issues in parallel, but real life got in the way the past few weeks.

While I welcome patches and help for PostgreSQL-related packages, it needs to be a coordinated effort. You can contact me by email, IRC (TitanOfOld or TitanOfOld|work), or Google+.
Comment 9 Aaron W. Swenson gentoo-dev 2013-09-15 21:23:34 UTC
*postgresql-base-9.3.0-r1 (15 Sep 2013)
*postgresql-base-9.2.4-r1 (15 Sep 2013)
*postgresql-base-9.1.9-r1 (15 Sep 2013)
*postgresql-base-9.0.13-r1 (15 Sep 2013)
*postgresql-base-8.4.17-r1 (15 Sep 2013)

  15 Sep 2013; Aaron W. Swenson <titanofold@gentoo.org>
  +postgresql-base-8.4.17-r1.ebuild, +postgresql-base-9.0.13-r1.ebuild,
  +postgresql-base-9.1.9-r1.ebuild, +postgresql-base-9.2.4-r1.ebuild,
  +postgresql-base-9.3.0-r1.ebuild, postgresql-base-9999.ebuild:
  Add Python support for clients and libraries. Fixes bug 392673.

*postgresql-server-9.3.0-r1 (15 Sep 2013)
*postgresql-server-9.2.4-r1 (15 Sep 2013)
*postgresql-server-9.1.9-r1 (15 Sep 2013)
*postgresql-server-9.0.13-r1 (15 Sep 2013)
*postgresql-server-8.4.17-r1 (15 Sep 2013)

  15 Sep 2013; Aaron W. Swenson <titanofold@gentoo.org>
  +postgresql-server-8.4.17-r1.ebuild, +postgresql-server-9.0.13-r1.ebuild,
  +postgresql-server-9.1.9-r1.ebuild, +postgresql-server-9.2.4-r1.ebuild,
  +postgresql-server-9.3.0-r1.ebuild, postgresql-server-9999.ebuild:
  Add Python support for clients and libraries. Fixes bug 392673.