PostgreSQL error when trying to create an extension

In C:\Program Files\PostgreSQL\9.4 I found uninstall-postgis-bundle-pg94x64-2.1.5-2.exe. Running that fixed my problem, which was caused by a reinstall of PostgreSQL without first uninstalling, and without installing PostGIS the second time around. That's what happens when you more than one person installing stuff..

On 14.04, there is [`postgresql-9.3-postgis-scripts`][1], which [contains][2] the `postgis.control` file.


[1]:

[To see links please register here]

[2]:

[To see links please register here]

I had my worst nightmare while installing Postgis 2.X on SLES 12 SP1. which doesnt have compatible package in zypper repo

Here is how is resolved it on my Postgres server instance running 9.4.X

**Prerequsite packages which i have installed prior to PostGis based on the errors**

Proj 4 Download source cold, Build --> make install
install Gdal andjibson by adding zypper repo zypper addrepo

[To see links please register here]

zypper install gdal gdal-devel libjson-c-devel libjson

**Installing Postgis**

Download postgis source code (

[To see links please register here]

)

Go to Postgis folder
./configure --with-pgconfig=/usr/lib/postgresql94/bin/pg_config --with-geosconfig=/usr/local/bin/geos-config
make
make install

now if you goto postgress DB and create extension postgis; it will work

**Important** while configuring you should specify pg-config path and geosconfig path and You SHOULD NOT include "without Raster" as RASTER plays main role in creating the postgis extension

this work for me


SELECT PostGIS_full_version();

To create postgisis run above query in query panel

And for remove postgis from your database run bellow query

drop extension postgis

Try this

apt-get install postgis

if you are using windows system download the `postgis.bundle.exe` and manually install in `C:/(PostgreSQLdirectory/version/ )` and that's all .