What is the easiest one click install method for PostGIS and it's entire dependencies?

Question

For someone new to database servers and their dependencies, what is the easiest assured way of installing PostGIS on a machine with no other software beyond what comes with its operating system? I'd like to know for Ubuntu, Windows and if possible a common Linux method. I'm understanding that you need to install PostGreSQL first, but before that perhaps you need to install Apache Server, and I'm not sure if that has dependencies.

Perhaps there a single binary that loads EVERYTHING for Windows, and maybe there a single program from the Ubuntu GIS repositories that installs everything. If not, what's the install order?

Postgis doesn't need for Apache. – Pablo Apr 19 '13 at 18:58 — Pablo, Apr 19 '13 at 18:58

score 6 · Answer 1 · answered Apr 18 '13 at 16:07

I have found for windows users using the Enterprise Postgres Installers with StackBuilder the easiest way to get up and running from a clean install (no previous versions of database etc.)

The PostgreSQL installers include the database server, pgAdmin and StackBuilder.

Notes: **Internet Connection is required during the install as downloads items based on users input.

Versions 9.0, 9.1 and 9.2 below have been updated to incorporate the security patches released on Thursday, April 4th, 2013.

Download from:

http://www.enterprisedb.com/products-services-training/pgdownload

Installation Guide available:

http://www.enterprisedb.com/resources-community/pginst-guide

score 4 · Answer 2 · answered Apr 19 '13 at 19:03

4

For Ubuntu

sudo apt_get install postgresql postgis postgresql-9.1-postgis

sudo -i -u postgres
createdb postgis
psql -d postgis -f /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql
psql -d postgis -f /usr/share/postgresql/9.1/contrib/postgis-1.5/spatial_ref_sys.sql
psql -d postgis -f /usr/share/postgresql/9.1/contrib/postgis_comments.sql

answered Apr 19 '13 at 19:03

Pablo

9,827
6
43
73

Is CREATE EXTENSION postgis only for PostGis 2.0? – djq Apr 21 '13 at 19:22
Nop. CREATE EXTENSION, is for PostgreSQL 9.x :) – Taber Apr 22 '13 at 16:21

score 1 · Answer 3 · answered Apr 18 '13 at 16:14

The easiest way (at least in Windows):

You can use, use EnterpriseDB installer (windows & linux), once you had installed PostgreSQL, use "StackBuilder" utility to install PostGIS optional library (PostGIS recommends this method in his web site)

Then you need to install pgAdminIII to connect to PostgreSQL.

What is the easiest one click install method for PostGIS and it's entire dependencies?

3 Answers3

Linked