Re: Installing PostGIS 2.0

James David Smith <james(dot)david(dot)smith(at)gmail(dot)com> writes:
> I'm currently running PostgresSQL 8.4 with PostGIS 1.5, but figured
> it's about time that I upgraded to a more recent version. I had
> decided not to do this until now as I wanted to use PgRouting, but I
> see that Sanak has wonderfully made this possible now, so just now I
> downloaded and installed PostgresSQL 9.1. This seemed to go well.
> However I then launched Stack Builder and asked it to download and
> install PostGIS 2.0. Towards the end of this process however I was
> given an error which was :

> ERROR: syntax error at or near "EXTENSION"
> LINE 1: CREATE EXTENSION postgis;
> ^

That does not look like you are running a 9.1 server. You certain
you're not still talking to the 8.4 installation?

regards, tom lane