Error Could Not Access File $libdir/liblwgeom
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us could not access file "$libdir/plpgsql": no such file or directory Learn more about Stack Overflow the company Business Learn more about hiring developers
Postgres Set Libdir
or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack
Postgres Change Libdir
Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Problems with $libdir on PostgreSQL up vote
Error: Could Not Access File "$libdir/postgis-2.2": No Such File Or Directory
10 down vote favorite In short, my question is "why doesn't $libdir work on my PSQL installation." CREATE FUNCTION st_box2d_in(cstring) RETURNS box2d AS '$libdir/liblwgeom', 'BOX2DFLOAT4_in' LANGUAGE c IMMUTABLE STRICT; yields an error could not access file "$libdir/liblwgeom": No such file or directory while CREATE FUNCTION st_box2d_in(cstring) RETURNS box2d AS '/usr/local/pgsql/lib/liblwgeom', 'BOX2DFLOAT4_in' LANGUAGE c IMMUTABLE STRICT; works correctly. The output of % pg_config --pkglibdir /usr/local/pgsql/lib appears to be could not access file "$libdir/postgis-1.5": no such file or directory correct. postgresql postgis pg-dump share|improve this question edited Aug 28 '09 at 21:26 asked Aug 28 '09 at 19:51 Joe Germuska 1,11511425 This should work. Perhaps you are mixing different installations? –Peter Eisentraut Sep 14 '09 at 10:42 add a comment| 2 Answers 2 active oldest votes up vote 4 down vote I struggled with this error as well. I solved it by linking in the PostGIS lib manually to the liblwgeom file, like this: ln -s /usr/lib/postgis/1.5.1/postgres/8.4/lib/postgis-1.5.so /usr/lib/postgresql/8.4/lib/liblwgeom I have no idea why PostGIS installs itself in the 'wrong' directory, or why PostgreSQL looks for a file named liblwgeom when it seems to be the same file which PostGIS calls postgis-1.5.so All I know is that that seems to have fixed my problem. share|improve this answer edited Jun 20 '11 at 16:35 Christian Specht 23.1k865120 answered Jun 20 '11 at 8:27 Johan.l 412 Nicely done, I did ln -s /Library/PostgreSQL/9.1/lib/postgis-1.5.so /Library/PostgreSQL/9.1/lib/postgresql/postgis-1.5 for my installation –Aram Kocharyan Oct 20 '12 at 3:56 add a comment| up vote 1 down vote Edited out original reply for it was wrong Now that I've looked up postgresql code I have to admit that this string is supposed
Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Geographic Information Systems Questions Tags Users Badges Unanswered Ask Question _ Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Migration from postgresql 8.4 to postgresql http://stackoverflow.com/questions/1349001/problems-with-libdir-on-postgresql 9.0, postgis 1.5 involved up vote 3 down vote favorite 1 Im migrating from 8.4 to 9.0, in pg8.4 i have postgis 1.5.1 and in 9.0 im just installed 1.5.2. I decided to dump the postgis databases before the pg_upgrade command, and delete them, planning to create my new postgis_template and then create the databases: pg_dump -C -h host -U postgres -f databasegis.dump databasegis psql -U postgres < databasegis.dump But I have errors : ERROR: could not http://gis.stackexchange.com/questions/14210/migration-from-postgresql-8-4-to-postgresql-9-0-postgis-1-5-involved access file "$libdir/liblwgeom": No such file or directory ERROR: function public.st_text(boolean) does not exist What can i do? Thanks a lot. postgis postgresql share|improve this question asked Sep 1 '11 at 13:31 avances123 337315 What Operating System are you using? –Mapperz♦ Sep 1 '11 at 13:46 add a comment| 4 Answers 4 active oldest votes up vote 3 down vote This method worked. Create a new database. Install PostGIS 1.5 (the install files should be in share/contrib/postgis-1.5). Then restore your data on top. You should then get errors that the functions already exist and they will be skipped. You may get some errors too about the liblwgeom, but those you can ignore since they represent functions long ago deprecated that got taken out of postgis-1.5. share|improve this answer edited Sep 1 '11 at 20:00 Peter Eisentraut 1685 answered Sep 1 '11 at 13:46 Mapperz♦ 39.9k646107 add a comment| up vote 2 down vote accepted I've just find the best method, I used a script in postgis package called /usr/share/postgresql-9.0-postgis/utils/new_postgis_restore.pl This path my be different in your systems but only got a few duplicate primary key errors. share|improve this answer answered Sep 7 '11 at 15:36 avances123 337315 add a comment| up vote 0 down vote liblwgeom was renamed to postgis in version 1.4. Are you sure you are updating from 1.5? If you are migrating a major versio
communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might http://askubuntu.com/questions/462202/postgis-could-not-access-file-libdir-postgis-2-1-no-such-file-or-directory have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Ask Ubuntu Questions Tags Users Badges Unanswered Ask Question _ Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes could not a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Postgis + could not access file “$libdir/postgis-2.1”: No such file or directory up vote 8 down vote favorite 1 I am running postgresql9.3 and postgis2.1 , it works fine. When could not access i installed QGIS by using the following commands: sudo apt-get update sudo apt-get install qgis After installing QGIS the postGis is not working. When i tried to execute a spatial query, it shows error: could not access file "$libdir/postgis-2.1": No such file or directory SO i uninstalled QGIS , but now also i get the same error. I searched a lot regarding this, i cant find the solution. Help me to solve this. Thanks in advance.. postgresql share|improve this question asked May 7 '14 at 9:43 Subburaj 14114 I solved the problem .. I reinstalled libgdal and postgis .. it works fine now.. –Subburaj May 7 '14 at 12:24 add a comment| 2 Answers 2 active oldest votes up vote 5 down vote You can reinstall the postgis extension for PostgreSQL, it worked for me : sudo apt-get install postgresql-9.3-postgis-2.1 share|improve this answer answered Mar 11 '15 at 10:35 Kmaschta 5112 5 same in OS X brew uninstall postgis - brew install postgis –n1000 May 25 '15