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 <[email protected]> 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 > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
