After install postgis: emerge --config postgis says: createdb: invalid option -- 'q' Try "createdb --help" for more information. * * ERROR: dev-db/postgis-1.5.2 failed. etc... Reproducible: Always Steps to Reproduce: 1. emerge postgresql-server ( 9.0 ) 2. emerge postgis New postgis have no files lwpostgis.sql, but it has in ebuild. New postgresql's createdb have no option -q. I try to fix it in ebuild. Please, see and correct if needed.
Created attachment 249139 [details] fix some issues with new postgresql
I had the same issue and the patch helped me to do 'emerge --config postgis', but I still can't reconstruct my postgres database. If I try 'psql -U postgres -d postgres -f pg_dumpall-8.3', I get: ... psql:pg_dumpall-8.3:72: ERROR: could not access file "/usr/lib/postgresql//liblwgeom": No such file or directory psql:pg_dumpall-8.3:75: ERROR: function public.st_box2d_in(cstring) does not exist psql:pg_dumpall-8.3:83: ERROR: could not access file "/usr/lib/postgresql//liblwgeom": No such file or directory psql:pg_dumpall-8.3:86: ERROR: function public.st_box2d_out(box2d) does not exist Any hint is appreciated.
Created attachment 268433 [details] fixed ebuild DONE: - fixed all the paths used in pkg_config() - fixed load_before_upgrade.sql generation (the format changed a little with an extra line appearing after the 'C' one in some cases) - removed emerge time checking for previous version (troublesome during development). Now we always build and install load_before_upgrade.sql and we always do soft-upgrades on existing, spatially-enabled databases. Testing revealed no problems. - added logic for handling existing databases that weren't spatially enabled prior to being added to /etc/conf.d/postgis_dbs - added a message about the 2 new tables probably needing some extra rights (the owner is usually postgres) TODO: - remove code duplication by writing some functions or improving the logic Please test the ebuild and report any problems.
01 May 2011; Aaron W. Swenson <titanofold@gentoo.org> +postgis-1.5.2-r1.ebuild, +files/postgis_dbs, metadata.xml: Fixes bug 273960, 285082, 296172, 314243, 325113 and 339312