[postgis-users] Creating postGIS extension

[David Haynes]

Hello,

I'm having a bit of trouble getting the PostGIS extension on a new VM. It seems there were some earlier conflicts between gdal 2.0, but I have resolved them. However, I can't create the PostGIS extension. 

psql (PostgreSQL) 10.5 (Ubuntu 10.5-1.pgdg14.04+1)

david@david-VirtualBox:~$ psql -d research -c "CREATE EXTENSION postgis;"

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

The PostGIS control file is at /usr/share/postgresql/10/extension/postgis.control.

How can I point the server to this directory? Should I remove the older versions of PostgreSQL and leave only version 10. There isn't any data loaded.

[Darafei "Komяpa" Praliaskouski]

Hi,

Check that you are indeed connecting to Postgres 10 database. It looks like you are connecting to 9.3 instance. Likely you need to change port in your psql connection parameters.

select version();

пт, 7 сент. 2018 г. в 20:21, David Haynes <hayn...@gmail.com>:

_______________________________________________
postgis-users mailing list
postgi...@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

--

Darafei Praliaskouski
Support me: http://patreon.com/komzpa

[Sandro Santilli]

On Fri, Sep 07, 2018 at 12:20:57PM -0500, David Haynes wrote:
> Hello,
>
> I'm having a bit of trouble getting the PostGIS extension on a new VM. It
> seems there were some earlier conflicts between gdal 2.0, but I have
> resolved them. However, I can't create the PostGIS extension.

You may want to try my experimental branch making GDAL an optional
dependency (only needed if you want to use raster, which in my PR
is a separate extension "postgis_raster"). The code is here:

https://git.osgeo.org/gitea/postgis/postgis/pulls/20

--strk;

[Prosenjit Kumar]

On Saturday, September 8, 2018 at 3:26:29 PM UTC+6, Sandro Santilli wrote:

On Fri, Sep 07, 2018 at 12:20:57PM -0500, David Haynes wrote:
> Hello,
>
> I'm having a bit of trouble getting the PostGIS extension on a new VM. It
> seems there were some earlier conflicts between gdal 2.0, but I have
> resolved them. However, I can't create the PostGIS extension.

You may want to try my experimental branch making GDAL an optional
dependency (only needed if you want to use raster, which in my PR
is a separate extension "postgis_raster"). The code is here:

 https://git.osgeo.org/gitea/postgis/postgis/pulls/20

--strk;

I've used already but doesn't work and seems to same error.

[Puneet Makhija]

Hello David please help me in this !
have you got the answer for the same
 actually i am stuck in GDAL issues and after this postgis.control issue from last week. But my GDAL is working , now the issue of postgis come, please please i request please help me in this postgis issue