Hi, What is the *first* error message returned by the command: psql -d james_test -f /usr/pgsql-9.0/share/contrib/postgis-2.0/postgis.sql
Nicolas On 5 August 2013 19:15, James David Smith <[email protected]> wrote: > Hi there, > > I'm trying to make and compile PostGIS 2.0 with PostgreSQL 9.0. My > verrsion of PostgreSQL is: > > PostgreSQL 9.0.4 on x86_64-unknown-linux-gnu, compiled by GCC gcc > (GCC) 4.1.2 20080704 (Red Hat 4.1.2-48), 64-bit > > A work colleague and I havee been following the steps here: > > http://postgis.net/docs/postgis_installation.html > > However when we try to do this command it fails: > > psql -d james_test -f /usr/pgsql-9.0/share/contrib/postgis-2.0/postgis.sql > > The messages we get are all similar to this: > > psql:/usr/pgsql-9.0/share/contrib/postgis-2.0/postgis.sql:4783: ERROR: > current transaction is aborted, commands ignored until end of > transaction block > > Could the problem be that Postgis 1.5 is still installed/present? I > ask, as if I run the following command itseems to work fine: > > psql -d james_test -f /usr/pgsql-9.0/share/contrib/postgis-1,5/postgis.sql > > Any ideas? By the way, I appreciate that the ideal solution might be > to upgrade PostgreSQL to 9.1 but having got this far I'd like to try > and 'finish' this if possible. > > Thanks > > James > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
