[GIS] Installing PostGIS in PostgreSQL 10

installationpostgis

In earlier version we could install the PostGIS using the Stack Builder but now it is not showing the option of spatial extension. Can anyone help me install it?

Best Answer

The doc says

Installers are available for 9.6 64/32-bit on stackbuilder [...]
Installers for PostgreSQL 10 64-bit are available on experimental, and osgeo downloads and will be available shortly on EDB appliction stack builder

--> it's not yet available in Stack Builder.

You can install Postrgres first, then download and install PostGIS

Related Solutions

PostGIS – Troubleshooting Installation on PostgreSQL 9.1

By default, you don't have PostGIS 2.0 but 1.5 (see http://packages.ubuntu.com/fr/precise/postgresql-9.1-postgis)

By doing CREATE EXTENSION postgis; you're trying to initialize from PostgreSQL with the new loading mechanism a PostGIS version (1.5) that do not support it and in this case, you will need to follow the PostGIS 1.5 official doc

If you need 2.0, follow various instructions already available in previous gis.stack.exchange.com answers e.g Install PostGIS on Ubuntu 12.04 or Can POSTGIS 2.0 be install with POSTGRES 9.2 on Ubuntu 12.04 OS at the moment?

Edit due to changes in question:

When I look in the repository (http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main), I see you can get different PostGIS versions for different PostgreSQL versions, so sudo apt-get install postgis is not enough clear for the package manager

Did you try?

sudo apt-get install postgresql-9.1-postgis-2.0

[GIS] Stack Builder not finding spatial extentions for Postgre 10 when installing PostGIS

nJGL yah sorry the folks that manage the Stackbuilder stuff are on vacation I was told. So issue is still there. I did upload the exes to Stackbuilder so as soon as the issue is fixed they would show up there.

The stackbuilder will just give you the same installer files you'll find here.

http://winnie.postgis.net/download/windows/pg10/buildbot/

For 64-bit http://winnie.postgis.net/download/windows/pg10/buildbot/postgis-bundle-pg10x64-setup-2.4.1-1.exe

I haven't packaged pg10 32-bit since I'm having issue with the pointcloud build, hopefully you don't need that. If you need the 32-bit just use the binaries.

Best Answer

Related Solutions

PostGIS – Troubleshooting Installation on PostgreSQL 9.1

[GIS] Stack Builder not finding spatial extentions for Postgre 10 when installing PostGIS

Related Question