[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: [DebianGIS] Where is the postgis in etch documentation?

On Sun, Dec 17, 2006 at 09:57:30AM +0100, Petter Reinholdtsen wrote:
> I sent this message via gmane yesterday, but it did not show up on the
> list yet.  I try again directly to the list address.
> I tried to set up a postgis database in Debian/etch the other day, and
> ran into a few problems with lack of documentation.  Is there an howto
> somewhere?  I had a look in the files included in the packages, like
> /usr/share/doc/postgresql-8.1-postgis/README.Debian,
> /usr/share/doc/postgis/README.postgis.gz and
> /usr/share/doc/postgis/postgis.html, but no-one had specific
> instructions for etch.  The HTML file was closest.
> At the end, I made the following notes on how to get it working.
> Should something like this be added to
> /usr/share/doc/postgresql-8.1-postgis/README.Debian?
> How to create a postgis database in Debian/etch
> ===============================================
> Short intro on how to set up a postgis database in Debian/etch.  All
> the packages are there, but the wrapper script handling it all is
> missing.  These are the steps I took to get it working.
> As root:
>   # Install the needed packages
>   aptitude install postgresql-8.1-postgis postgis
>   # Become a postgresql superuser (needed to load the postgis features?)
>   su - postgres
>   # Create the user and her database
>   createuser <username>
>   createdb <username>
>   # Need to enable plpgsql for the database beforeloading the functions
>   createlang plpgsql -d <databasename>
>   # Finally, load the functions and reference system tables
>   psql <databasename> -f /usr/share/postgresql-8.1-postgis/lwpostgis.sql
>   psql <databasename> -f /usr/share/postgresql-8.1-postgis/spatial_ref_sys.sql

Ack, this can be added for etch ASAP. Anyone doing an update for that?

Francesco P. Lovergine

Reply to: