[GIS] PostGIS extension not available in Postgresql list

postgispostgresql

I have installed Postgresql 9.2 from graphical installer in Ubuntu 13.10 and Install PostGIS 2.0.3 through StackBuilder. All things went smooth. But it is not possible to create PostGIS database as there is no extension present in Extension. As far I know two more extension is needed to be there named 'postgis' and 'postgis_topology'. I have tried

CREATE EXTENSION postgis

but it returns there is no postgis.control file within the extension folder. What should I do now?

Best Answer

The postgresql apt-repository has postgis now, and I put together some instructions for pulling from this to install postgresql 9.3 and postgis 2.1 (if that version of postgis will work for you).

View the instructions here, and let me know if they work for you!

I would steer clear of enterpriseDB especially for Ubuntu / Linux. They have told me on support forums that they are not really supporting postgis on Linux properly.

Related Solutions

PostGIS Installation – Fixing Missing template_postgis

You can quite easily create the template if it is not there automatically. Here is a description for ubuntu: http://obsessivecoder.com/2010/02/01/installing-postgresql-8-4-postgis-1-4-1-and-pgrouting-1-0-3-on-ubuntu-9-10-karmic-koala/

This is the essential part:

sudo su postgres
createdb template_postgis
createlang plpgsql template_postgis
psql -d template_postgis -f /usr/share/postgresql/8.4/contrib/postgis.sql
psql -d template_postgis -f /usr/share/postgresql/8.4/contrib/spatial_ref_sys.sql

In Precise Pangolin:

sudo su postgres
createdb template_postgis
psql -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql
psql -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-1.5/spatial_ref_sys.sql

[GIS] How to install pgRouting on PostgreSQL 9.2 located at /opt/PostgreSQL/9.2/ on Ubuntu Server 12.10

You can't install pgrouting for PostgreSQL 9.1 into PostgreSQL 9.2. Even if you could install the package without downloading all of 9.1, it wouldn't work, it'd just be unavailable - totally invisible to Pg 9.2.

If PgRouting is not included in EDB's StackBuilder you will need to build it from source code according to the instructions on the PgRouting website. See the source code readme for guidance on this process. When compiling pgrouting, you may need to add the appropriate pg_config to the PATH, e.g:

PATH=/opt/PostgreSQL/9.2/bin:$PATH

Alternately, you could use the PGDG packages of PostgreSQL for Ubuntu instead of the EDB installer. That will get you PostGIS and PgRouting for PostgreSQL 9.2 (or 9.3) via apt-get. See http://wiki.postgresql.org/wiki/Apt . This will do a new PostgreSQL installation - it won't use your existing database in /opt, so you will need to do a pg_dump and then restore the DB if there's any data you want to keep. It won't delete or replace the DB in /opt, it'll just create a new PostgreSQL on a different port, probably 5433.

Best Answer

Related Solutions

PostGIS Installation – Fixing Missing template_postgis

[GIS] How to install pgRouting on PostgreSQL 9.2 located at /opt/PostgreSQL/9.2/ on Ubuntu Server 12.10

Related Question