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 Commented Dec 11, 2014 at 3:21
  • Is there any reason you are using an outdated Postgres version? 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. 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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.