I am trying to install the
postgis extension on my database, which resides on a web hosting service. The problem is that the control files seem to have to be found in
/package/host/localhost/postgresq-9.3.2-1. I am using a hosting company where all we can access is what is in our respective
home/ folders. The Postgres executables are found in the root directories which we cannot access.
I have successfully installed the PostGIS binaries, but now when I try to create the extension with
CREATE EXTENSION postgis, I get the error
ERROR: could not open extension control file /package/host/localhost/postgresql-9.3.2-1/share/extension/postgis.control. I cannot write anything to this directory since it is just intended to store the executables for anyone to access via some scripts the hosting provider as set up.
Can I have this .control file be somewhere else instead? Or am I just out of luck entirely?