0

I am trying to add PostGIS functionality to a database that I created in PostgreSQL using the following command: psql -d <db_name> -f /location/to/this/file/postgis.sql

However, I receive a bunch of errors relating to 'geometry does not exist', but on line 1 of these error messages, it says ERROR: could not access file “$libdir/postgis-1.5”.

I Google'd and checked StackOverflow, and it seems like this error is related to dependencies or scripts not being installed. I installed PostGIS using yum install postgis84. I did not see any dependencies except for proj. Based on these instructions, it seems like I will need Proj4, GEOS, LibXML2, GDAL, JSON-C, etc.

Is there a repository that I can connect to that will let me install PostGIS with all the crucial dependencies rather than installing them one by one? I am running a Red Hat Enterprise Linux 6.5 server on Amazon EC2.

I am new to databases, so please excuse me if I used any incorrect lingo.

Improve this question
3
  • X-post to gis.stackexchange.com/q/125218/12379
    – Craig Ringer
    Commented Dec 11, 2014 at 3:21
  • Is there any reason you are using an outdated Postgres version?
    – user1822
    Commented Dec 11, 2014 at 8:34
  • @a_horse_with_no_name I am transferring a database from one server to another (EC2). My current database is Postgres 8.4.2. I would like to jump to 9.x eventually. I just wasn't sure if right now it would be appropriate as it may result in errors or incompatibility.
    – kaoscify
    Commented Dec 11, 2014 at 15:26

1 Answer 1

Reset to default
0

I solved it. I found the RPM's for GDAL, GEOS, and Proj4. They are located here: http://yum.postgresql.org/9.2/redhat/rhel-6-x86_64/

Since they are not packaged with PostgreSQL 8.4, you have to install them one by one. I hope this helps someone in future.

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.