Re: Installing PostGIS 2.0

Hi,

Apologies for another email.

Just thought that I'd say I ran stack builder and tried to install
PostGIS 2.0 into my PostgresSQL 8.4 database and it did it fine. Then
I went into my PostgreSQL 9.1 server and can now see the
template_postgis_20 database. Which I can now use and seems to be
fine. I even enabled PgRouting in it (thanks for the files Sanak). Bit
of an odd method to get PostGIS 2.0 working with 9.1 but it seems to
be working.

Cheers

James

On 7 June 2012 15:46, James David Smith <james(dot)david(dot)smith(at)gmail(dot)com> wrote:
> Hi all,
>
> I wonder if I need to remove PostGIS 1.5 first? I've attached a screen
> print of my PgAdminIII console incase if it shows anything useful.
>
> Thanks
>
> James
>
> On 7 June 2012 15:27, James David Smith <james(dot)david(dot)smith(at)gmail(dot)com> wrote:
>> 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