Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have installed the latest stable version of PostgreSQL v9.2 and I want to install the PostGIS v2 extension.

I've been searching for it for 3 days now, however can't find it.

I did however find PostGIS v2 for PostgreSQL v9.1, thanks to this site: http://linfiniti.com/2012/05/installing-postgis-2-0-on-ubuntu/

I'm an Ubuntu novice, I'm more accustomed to Windows.

The PostgreSQL v9.1 package doesn't work. Where can I get the correct package?

share|improve this question

2 Answers 2

From this listing it looks like there is a package named postgresql-9.2-postgis2. You may have to add a new apt repository to the existing ones. In this, you can find help here.

share|improve this answer
Thanks for this. I'm having some trouble understanding how to determine what the location of the repository is. Could you please advice me? –  Paul Meems Sep 28 '12 at 18:27
Can't exactly test it at the moment, but I guess adding a line deb http://apt.opengeo.org/stage/suite/v3/ubuntu lucid main to sources.list and running apt-get update would do it. (This asumes you use the lucid version.) If you don't succeed, I think you can get help from the opengeo.org site. –  dezso Sep 28 '12 at 19:27
I could't got it to work so I started over with a new Ubuntu server and installed Postgresql v9.1 and PostGIS v2 and it seems to be working. –  Paul Meems Oct 2 '12 at 19:00

You may try installing PostgreSQL 9.2 from repository then install PostGIS 2.0 from source using below commands:

Install GEOS(for topology support)

wget http://download.osgeo.org/geos/geos-3.3.9.tar.bz2
tar xfj geos-3.3.9.tar.bz2
cd geos-3.3.9
sudo make install

Install PostGIS 2.0

wget http://download.osgeo.org/postgis/source/postgis-2.0.6.tar.gz
tar xfz postgis-2.0.6.tar.gz
cd postgis-2.0.6
sudo make install
sudo ldconfig
sudo make comments-install

Source: how to install postgresql 9.2 + postgis 2.0

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.