How To Install PostGIS on Ubuntu (draft)

Installation

From Packages (aka, the easy way):

PostGIS and Postgresql are available as packages for Ubuntu 6.10 and greater. To install, use either:

apt-get install postgresql-8.3-postgis postgis

OR

Use adept or synaptic and select packages:

postgresql-8.3-postgis

postgis

NOTE: The "Universe" repository must be enabled.

NOTE: postgresql-8.3 is current as of 1/2009. You should, of course, use the current version.

From Source (aka, the hard way):

1. Install Postgresql, Libgeos, Proj. packages. Easiest way is to use Synaptic (be sure to include Universe in your respositories). Also be sure to install the "-dev" packages (postgresql-server-dev-8.0). Under Breezy, latest postgresql version is 8.0 (adjust following paths to reflect the version you have installed).

2. Download postgis.tgz and place in /usr/share/postgresql/8.0/contrib

3. Extract the via Nautilus or cd to the directory and then use tar -zvxf postgis-x.x.x

4. Now cd to the postgis directory.

5. Now configure. Try:

  > sudo ./configure --prefix=/usr  --with-pgconfig=/usr/bin/pg_config
    --with-geos=/usr/bin/geos-config  --with-proj=/usr

6. Check to see that you have no errors. You may need to install other packages (like flex and byacc).

7. Now type > sudo make

8. type > sudo make install

That should do it.

---

Using PostGIS

1. Create a database. You must be the postgres superuser to do this: = From the shell:

$ createdb mytestdb

TIP: if you get permission errors, try:

$ sudo su postgres $ createdb mytestdb

REMEMBER: type 'exit' when you're done with these postgres commands to return to your normal user.

2. Set up the postgis libs:

$ createlang plpgsql mytestdb

2a. If you installed from packages:

$ psql -d mytestdb -f /usr/share/postgresql-8.3-postgis/lwpostgis.sql

if there were no errors (if the last line of output is COMMIT), then

$ psql -d mytestdb -f /usr/share/postgresql-8.3-postgis/spatial_ref_sys.sql

NOTE: Fedora 7 installed from package path is /usr/share/pgsql/contrib/

2b. If you installed from source:

NOTE: this looks old…

$ psql -d mytestdb -f /usr/share/postgresql/8.0/contrib/postgis-1.1.1/lwpostgis.sql

$ psql -d mytestdb -f /usr/share/postgresql/8.0/contrib/postgis-1.1.1/spatial_ref_sys.sql

3. Make sure that your DB user has GRANT ALL on the "geometry_columns" table and GRANT SELECT on "spatial_ref_sys".

Now import a shp file:

$ shp2pgsql -D myshape.shp mytable mytestdb | psql mytestdb

This will take the input file "myshape.shp" and create a new table, "mytable" in the database "mytestdb."

To see if your shape file is there:

$ psql mytestdb mytestdb=# SELECT * from mytable;