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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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:

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

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 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 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)

tar xfj geos-3.3.9.tar.bz2
cd geos-3.3.9
sudo make install

Install PostGIS 2.0

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

Here you are a few steps:

  1. Install postgreSQL 9.x from packages;
  2. Configure ubuntugis repository from here;
  3. Add the following lines to /etc/apt/source.list with your ubuntu version:

  4. Run the command apt-get update

  5. Install postGIS library and all dependencies from synaptic;
  6. Create a new DB and configure PostGIS spatial extension as described here --> consider steps 2 and 3.
share|improve this answer
The links are subject to link rot, please consider adding the important substeps from them to your answer. Thanks in advance! – dezso Apr 27 '15 at 9:23

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.