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