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