Bug 296172 – dev-db/postgis-1.4.0 --config fails with postgresql-server-8.4

• Status: RESOLVED FIXED
• Product: Gentoo Linux

[Description kavol 2009-12-08 10:54:11 UTC]

I need recent versions of the tools for OpenStreetMap rendering. Unfortunately, the latest postgis fails to config because of two reasons:

1) /etc/conf.d/postgresql does not exist - there is only the versioned name /etc/conf.d/postgresql (can be fixed with symlink)

2) createdb does not accept the option -q (can be omitted)

3) spatial_ref_sys.sql is not in /usr/share/postgresql/contrib but rather /usr/share/postgresql-8.4/contrib (at this point, I gave up)

Reproducible: Always

[Comment 1 kavol 2009-12-08 10:55:31 UTC]

(In reply to comment #0)
> ... because of two reasons:
                 ~~~
                 ^ ahem :-)

[Comment 2 Rafał Mużyło 2009-12-08 11:57:06 UTC]

Does 'eselect postgresql' help ?

[Comment 3 kavol 2009-12-08 12:33:00 UTC]

(In reply to comment #2)
> Does 'eselect postgresql' help ?

does not seem so ...

I've removed the symlink I created:

# rm /etc/conf.d/postgresql

let's see what postgresql version is selected and available:

# eselect postgresql show
8.4
# eselect postgresql list
Available postgresql installations
  8.4 <-* <-S                base-8.4.1 server-8.4.1-r1

hm, 8.4 is selected, let's set it again to see if anything changes:

# eselect postgresql set 8.4
# ls /etc/conf.d/postgresql*
/etc/conf.d/postgresql-8.4

^ well, doesn't seem that the link would be recreated (or file renamed to the expected "postgresql" without version)

and the "-q" option is hardcoded to --config, I don't see a chance that eselect would change it for postgis?

and as for /usr/share/postgresql/contrib , it is not empty, so simple linking wouldn't work, so I'm not sure what eselect would be expected to do here?

[Comment 4 Rafał Mużyło 2009-12-08 13:27:34 UTC]

How about 'eselect postgresql show-all' ?
It's the service that you should be looking at,
not utilities.

[Comment 5 kavol 2009-12-08 13:39:44 UTC]

(In reply to comment #4)
> How about 'eselect postgresql show-all' ?
> It's the service that you should be looking at,
> not utilities.

um, sorry, I haven't noticed there are different options; here it goes:

# eselect postgresql show-all
Utilities:  8.4
Service:    8.4

and
# eselect postgresql set-all 8.4

doesn't seem to change anything

[Comment 6 Andreas Sturmlechner 2010-01-20 12:09:29 UTC]

confirmed. I'll try to get it to work.

[Comment 7 Andreas Sturmlechner 2010-01-20 13:57:45 UTC]

Created attachment 216969 [details, diff]
quick and dirty ebuild patch to make it work - and only - with postgresql-server-8.4

This ebuild enables postgis-1.4.0 to properly emerge --config and create the template_gis.

Be aware though that this ONLY works with postgresql-server-8.4 for now, which is why I bumped the version requirement in this ebuild.

TODO: detect installed postgresql version and thus set the install path.

[Comment 8 Aaron W. Swenson 2011-05-01 17:38:54 UTC]

  01 May 2011; Aaron W. Swenson <[e-mail]>
  +postgis-1.5.2-r1.ebuild, +files/postgis_dbs, metadata.xml:
  Fixes bug 273960, 285082, 296172, 314243, 325113 and 339312