[postgis-users] info

[Lee Hachadoorian]

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