Error when trying to run Create Extension postgis

Question

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?

DFE · Accepted Answer · 2013-09-24 10:39:04Z

3

UPDATE: the TEAM has just released the postgis.2.1.0-3 RPM package that solve the issue: now the extension is available:

/usr/pgsql-9.3/share/extension/postgis.control

END UPDATE. [...]

I resolved compiling POSTGIS from source. This is the step-by-step for CentOS 6.4 64bit:

wget http://download.osgeo.org/postgis/source/postgis-2.1.0.tar.gz
tar xvf postgis-2.1.0.tar.gz
cd postgis-2.1.0
./configure --with-pgconfig=/usr/pgsql-9.3/bin/pg_config --without-raster
make
make comments
make install
make install-comments
su - postgres 
cd /usr/pgsql-9.3/share/contrib/postgis-2.1/
psql -d postgres -f postgis.sql
psql -d postgres -f spatial_ref_sys.sql
psql -d postgres -f postgis_comments.sql
psql -d postgres -f topology.sql
psql -d postgres -f topology_comments.sql

edited Sep 24, 2013 at 10:39

answered Sep 24, 2013 at 10:27

DFE

511 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

daryl · Accepted Answer · 2013-10-02 20:48:32Z

2

The postgis2_93 RPM provided by http://yum.pgrpms.org/ is missing extension support. I reported this to Devrim earlier this week and he has been attempting to fix it.

http://svn.pgrpms.org/changeset/299

Hopefully the next push of RPMS to the website resolves this.

Update: postgis2_93-2.1.0-3 was released, which solved this issue but placed a rpm requirement for gdal 1.9, which EPEL does not provide. I got it from ELGIS.

edited Oct 2, 2013 at 20:48

answered Sep 13, 2013 at 18:41

daryl

1,20011 silver badges21 bronze badges

Comments

Vlad · Accepted Answer · 2017-04-05 21:09:57Z

0

For Postgresql 9.6 please try this commands:

yum install postgis
yum install postgis-client 
yum install postgresql96-contrib

answered Apr 5, 2017 at 21:09

Vlad

3,6371 gold badge34 silver badges27 bronze badges

Comments

Damith Asanka · Accepted Answer · 2019-09-21 11:46:38Z

I have same issue, so i fixed that using below steps

my environment is

Windows 10 , postgres sql 11 server and pgAdmin 4

download binary from (zip file not installer) http://download.osgeo.org/postgis/windows/pg11/postgis-bundle-pg11-2.5.3x64.zip
Extract zip file into folder
change the setting in "makepostgisdb_using_extensions.bat"
Run the file as Administrator if above steps gives error manually copy files based "makepostgisdb_using_extensions.bat" copy file in the Xcopy section eg. xcopy bin*.* "%PGBIN%" is equals to

extract_folder\bin into C:\Program Files\PostgreSQL\11\pgAdmin 4\bin

follow each xcopy command copy the relevant files 5. Restart postgre server 6. Run the 4 step in above sequence 7. or else you can create gis extension through the pgAdmin UI

========= Good luck

Collectives™ on Stack Overflow

Error when trying to run Create Extension postgis

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related