Wednesday, 6 May 2015

postgresql - Running Create Extension postgis gives ERROR could not open extension control file?


I have installed PostgreSQL 9.x and PostGIS 1.5/2.0 several times and have never had this problem.


I just got a new CentOS 6.3 server up and running and and I have Postgres 9.3 functioning as expected. I have run


yum install postgis2_93

and I can see the files in


/usr/pgsql-9.3/share/contrib/


however, when I run


CREATE EXTENSION postgis;

I receive


ERROR:  could not open extension control file "/usr/pgsql-9.3/share/extension/postgis.control": No such file or directory

the tutorials (#1, #2) I have used don't show any steps between installing PostGIS and creating the extension.


What am I missing?



Answer




If you can find a postgis.sql file, you can run that into your database (and the spatial_ref_sys.sql file) to manually spatialize your database. Report the missing control file to the packager, that's a big problem.


No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...