Re: Installing PostGIS 2.0

James David Smith <james.david.smith@gmail.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