3

I work on OpenSUSE 12.1 and after today's upgrade (2012 NOV 14) Postgres and Postgis doesn't work. If I login to Postgres server by PgAdmin, get the message: translated from polish "ERROR: can't acces to file "$libdir/postgis-2.0".Theres no file or directory"

When I want create spatial extension by typing " psql -d sulo1 -c "CREATE EXTENSION postgis;" " than I get : cannot open control extension "/usr/share/postgresql91/extension/postgis.control": no file and folder

Have to configure my postgis for a new upgrades?

Improve this question
7
  • Where did you get the update files for PostGIS from?
    – Mapperz ♦
    Commented Nov 14, 2012 at 15:24
  • There was automatic updates, from official repository. Update was for Postgis, Posgres, GDAL, QGIS and other. After update I have: -postgis2 2.0.1-2.3 -postgresql client 9.1.5+9.1.3.14.1 -postgresql91 9.1.6-9.1
    – tomsik
    Commented Nov 14, 2012 at 16:29
  • source of updates: download.opensuse.org/repositories/Application:/Geo/…
    – tomsik
    Commented Nov 14, 2012 at 17:02
  • I've tested that on 2 servers with OpenSUSE. Each one after automatic updates has that problem.
    – tomsik
    Commented Nov 15, 2012 at 6:40
  • 1
    Maybe it's looking at the wrong path. On my Ubuntu system, the path is /usr/share/postgresql/9.1/extension/postgis.control. A simple symlink at /usr/share/postgresql91/ might work as a temporary fix.
    – L_Holcombe
    Commented Nov 15, 2012 at 7:24

1 Answer 1

Reset to default
2

My problem was solved by me, but I am not glad with how I did it. OpenSUSE provided a patch to Postgres 9.1.7 which assumes different directory structure on the disk: / usr/share/postgresql91 / and not as before / usr / share / postgresql / This is the official upgrade OpenSSUSE number 775. However, Postgis (at now - 2012 NOV 18) is not prepared for this new patch and install it's $ libdir/Postgis-2.0 to the old catalogs structure. Uninstalling latest version of Posgres 9.1.6 and reinstall the PostGIS database was take effect, and it works. Below is a screenshot of how it looks like in my Yast.

installed packages

above are installed packages, below uninstalled packages

uninstalled packages

Thanks for help everyone, especially for symlinks - that was very important for the INVESTIGATION :-)

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.