[postgis-users] Problems installing on Linux

[Nicolas Ribot]

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 <james.david.smith at gmail.com> 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
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users