= 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

	Try to download the DEB package here:
	



'''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;