Re: Installing PostGIS 2.0

Am 07.06.2012 09:27, schrieb James David Smith:

I also believe you're talking to the old installation, why don't you
stop the 8.4 server and see what happens when you try to install
postgis. I bet it will tell you that it couldn't connect to the server.
If so, set your new server (9.1) to listen to port 5432, restart it and
retry the installation process.

Hope it helps you.

> Hi Tom,
>
> I don't think so. I went to the postgresql 9.1 folder and launched
> stack builder from there. It then asked me which installation of
> postgresql I was launching software for, so I selected 9.1. I then
> followed the steps and got this error.
>
> It seems like there is some error with PostGIS already being installed
> no? It goes to create a template and finds one there already?
>
> Thanks
>
> James
>
>
>
> I note that when I launch pgAdminIII I now have two servers. 8.4 and 9.1.
>
> On 7 June 2012 15:20, Tom Lane<tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> 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

--
pglearn.blogspot.mx <http://pglearn.blogspot.mx/>
*Twitter @iCodeiExist *