[postgis-users] PostGIS Installation Issues

[Mike Toews]

Here is an example from a shell (dash, the default for Ubuntu):

# (optional) Create a new empty database "mydb"
sudo -u postgres createdb mydb

# Add PL/pgSQL as a language
sudo -u postgres createlang plpgsql mydb

# Spatially enable it (from the 1.5 and 8.4 stocks, edit this
depending on which combinaiton you have):
sudo -u postgres psql -f
/usr/share/postgresql/8.4/contrib/postgis-1.5/postgis.sql mydb
sudo -u postgres psql -f
/usr/share/postgresql/8.4/contrib/postgis-1.5/spatial_ref_sys.sql mydb

If you want to see the error messages in more detail, then add " 2>
myerrout" to the end of the last two commands above, then view the
myerrorout file afterwards.

-Mike

On 4 May 2010 12:32, yoda2nd <yoda2nd at niacc.org> wrote:
> Hello all,
>
> I have been trying to install PostGIS on Ubuntu Server for the last few
> days, however for some reason I can not get the SQL files (postgis.sql,
> spatial_ref_sys.sql, etc.) into the database.  All I get is a screenfull
> of the following:
>
> psql:/gis/source_code/postgis-1.5.1/postgis/postgis.sql:7458: ERROR:
> current transaction is aborted, commands ignored until end of
> transaction block
> psql:/gis/source_code/postgis-1.5.1/postgis/postgis.sql:7465: ERROR:
> current transaction is aborted, commands ignored until end of
> transaction block
> psql:/gis/source_code/postgis-1.5.1/postgis/postgis.sql:7472: ERROR:
> current transaction is aborted, commands ignored until end of
> transaction block
> psql:/gis/source_code/postgis-1.5.1/postgis/postgis.sql:7478: ERROR:
> current transaction is aborted, commands ignored until end of
> transaction block
> psql:/gis/source_code/postgis-1.5.1/postgis/postgis.sql:7485: ERROR:
> current transaction is aborted, commands ignored until end of
> transaction block
>
> ./configure, make, make install all run fine without any errors that I
> can see.   Any help would be much appreciated!
>
> Thanks
> yoda2nd
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>