My webhosting company has installed postgreSQL 9.3.2 (on a Centos 5.1 VPS that is running Cpanel), but they have given up on trying to install postGIS 2.0.4.
CREATE EXTENSION postgis;
works, but none of the functions are actually installed.
How can I install postGIS?
I try importing the postgis--2.0.4.sql file and get this error:
could not load library "/usr/pgsql-9.3/lib/postgis-2.0.so": /usr/pgsql-9.3/lib/postgis-2.0.so: undefined symbol: GETSTRUCT
The file postgis-2.0.so is at that location.