[ELGIS] Untangling pgdg postgresql90 from Centos and ELGIS

[Bill Thoen]

Thanks, Peter!

The reference to 
http://www.postgresql.org/docs/8.4/static/install-upgrading.html  looks 
like just what I needed. Now I think I can do this and not make a mess.

- Bill Thoen

On 10/5/2011 2:07 PM, Peter Hopfgartner wrote:
> --------Bill Thoen<bthoen at gisnet.com>  wrote--------
>
> Subject: Re: [ELGIS] Untangling pgdg postgresql90 from Centos and ELGIS
>
> Date: 05.10.2011 18:23
>
>
>
>> On 10/5/2011 6:17 AM, Peter Hopfgartner wrote:
>>> On 10/05/2011 01:30 AM, Bill Thoen wrote:
>>> Hi Bill
>>>> Not knowing what I was doing several months ago I installed the
>>>> pgdg90 repository, because I wanted to get version 9.0 of podstgres.
>>>> It seemed to work; there were no problems. But now I've got all kinds
>>>> of compatibility problems as I find out that elgis and pgdg90 really
>>>> aren't compatible. So I 've got to do something about this now.
>>> Is there any particular feature in PostgreSQL 9.0 you really need? Is
>>> 8.4 an option for you?
>>> (...)
>> I can use 8.4 just fine. The only reason I tried the pgdg90 version was
>> that it supported a newer version of postgres (and I thought then that
>> newer is always better) and it seemed to work just fine. THee after a
>> couple of upgrades problems developed with errors about missing
>> dependencies, etc.
>>>> Then it occurred to me that maybe I should ask for advice before
>>>> doing any (more) damage. What do you all recommend I do to  get back
>>>> to PostgreSQL 8.4 and make ELGIS the primary source for postgres
>> again?
>>>> Thanks in advance; I really appreciate all your help!
>>> Otherwise it would save you some head aches not to rely on yet another
>>> repo which has many packages in common with ELGIS. We are running a
>>> discrete number of server with CentOS 5 and the postgresql84 packages
>>> and they run without any flaws.
>> Yes, that's what I'm asking about. How do I get back to using postgres
>> 8.4 (which elgis supports), with all my data intact? What's the startegy?
>> Right now, my thought is to make a full backup of the data using pg_dump
>> with the -Fc option, then wipe postgres off the system using yum remove
>> postgresql90, delete the pgdg09 repo and cache, then run yum install
>> postgresql, using the elgis repo, and finally, restore my data with
>> pg_restore. Is that the best way to do this? Or am I missing something
>> important?
> As said before, consider installing postgresql84 instead of postgresql, which is still at version 8.1. PostgreSQL 8.4 has a lot of nice features more then 8.1 and it seems to be faster in a large number of use cases.
>
>> Could it be that this is one of those situations where the experts see
>> the train wreck coming and don't want to have anything to do with it?
>> ;-)
>
>
> I hope you have still a running PostgreSQL installation. Then the standard upgrade procedure, as described in http://www.postgresql.org/docs/8.4/static/install-upgrading.html, should be also fine for downgrading.
>
>
>
>> TIA,
>> - Bill Thoen
>
>
> Peter Hopfgartner
>
>
>
> R3 GIS Srl - GmbH
>
> http://www.r3-gis.com
>
>
>