Hi Chris,
I ran into the same problem on Ubuntu 7.10. Lwpostgis.sql would not run
to completion, and all commands would be rolled back. Believe it or not
I got through it by opening lwpostgis.sql and running each block of
commands separately. I got through everything without ever finding out
what it had been stumbling on, and my PostGIS install is up and running.
Lee Hachadoorian
PhD Student, Geography
Program in Earth & Environmental Sciences
CUNY Graduate Center
Chris H wrote:
Greets:
Currently working on installing osm/mapnik support for gpsdrive. This requires
postgres and postgis integration. As this is a first run with all of this I'm
rather new to postgis.
Was wondering if anyone could offer some insight or advise on how to diagnose
the following problem. The instruction set that I'm following reads as
follows:
$> su
#> su - postgres
$> <commands...>
As the postgres user run the following to create the database:
NOTE: Replace username with the user that will be using mapnik.
$> createuser username
$> createdb -E UTF8 -O username gis
$> createlang plpgsql gis
This all works fine. No issues here. However the next set of commands barf
consistently.
4.1 As the postgresql super user:
NOTE: Replace username with the user that will be using mapnik.
$> psql -d gis -f /usr/share/postgresql-8.3-postgis/lwpostgis.sql
$> echo "ALTER TABLE geometry_columns OWNER TO username; ALTER TABLE
spatial_ref_sys OWNER TO username;" | psql -d gis
$> exit
#> exit
The line "psql -d gis -f /usr/share/postgresql-8.3-postgis/lwpostgis.sql"
returns the following:
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:1557: ERROR: current
transaction is aborted, commands ignored until end of transaction block
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:1563: ERROR: current
transaction is aborted, commands ignored until
This error repeats all the way up to 6430 until the command "ROLLBACK" is
issued.
How I can diagnose the source of this error as its been plaguing me on 8.2 as
well as 8.3. System is latest Kubuntu with all updates and the user chris123
has access to postgresql.
Kind regards for any insight or info.
Best and thanks
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
