[ELGIS] Untangling pgdg postgresql90 from Centos and ELGIS

[Hatzopoulos, Nikolaos]

FIRST COMMENT.. I hope you have a backup of your DB
when you change major versions on something keep in mind to have backups

ex I haven't upgrade my webserver to php5 :)

--Nikos Hatzopoulos
________________________________
From: el-bounces at lists.osgeo.org [el-bounces at lists.osgeo.org] on behalf of Bill Thoen [bthoen at gisnet.com]
Sent: Tuesday, October 04, 2011 4:30 PM
To: el at lists.osgeo.org
Subject: [ELGIS] Untangling pgdg postgresql90 from Centos and ELGIS

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.

I just made a complete pg_dump backup of all my postgres data which amounts to about 27 Gb of data so far, and so far I'm the only one on the server so I have that little luxury and I've got several Tb of free space  so I don't have to worry about running out of space yet either. What I'm looking for is some advice about how to go about fixing this this repo-mismatch. Here's what I've got (It's a CentOS 5.5 system):

# uname -a
Linux walden.gisnet.local 2.6.18-238.19.1.el5xen #1 SMP Fri Jul 15 08:16:59 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux


And here's my repositories:

# yum repolist
Loaded plugins: allowdowngrade, changelog, downloadonly, fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.nwresd.org
 * epel: mirror.steadfast.net
 * extras: centos-distro.cavecreek.net
 * updates: mirror.steadfast.net
pgdg90-source/primary_db                               |  19 kB     00:00
http://yum.pgrpms.org/srpms/9.0/redhat/rhel-5-x86_64/repodata/primary.sqlite.bz2: [Errno -3] Error performing checksum
Trying other mirror.
repo id            repo name                                            status
base               CentOS-5 - Base                                      3,566
elgis              EL GIS 5 - x86_64                                      136
epel               Extra Packages for Enterprise Linux 5 - x86_64       6,730
extras             CentOS-5 - Extras                                      235
pgdg90             PostgreSQL 9.0 5 - x86_64                              132
pgdg90-source      PostgreSQL 9.0 5 - x86_64 - Source                       0
updates            CentOS-5 - Updates                                       0
repolist: 10,799

I first tried to downgrade postgres90 (9.0.5) but got this:

# yum downgrade postgresql90
Loaded plugins: allowdowngrade, changelog, downloadonly, fastestmirror
Setting up Downgrade Process
Loading mirror speeds from cached hostfile
 * base: centos.mirrors.tds.net
 * epel: mirror.steadfast.net
 * extras: centos.mirrors.tds.net
 * updates: mirror.steadfast.net
pgdg90-source/primary_db                               |  19 kB     00:00
http://yum.pgrpms.org/srpms/9.0/redhat/rhel-5-x86_64/repodata/primary.sqlite.bz2: [Errno -3] Error performing checksum
Trying other mirror.
Error: failure: repodata/primary.sqlite.bz2 from pgdg90-source: [Errno 256] No more mirrors to try.

Then I tried just getting rid of postgres and reinstalling. But I didn't get far.

# yum remove postgres90
Loaded plugins: allowdowngrade, changelog, downloadonly, fastestmirror
Setting up Remove Process
No Match for argument: postgres90
Loading mirror speeds from cached hostfile
 * base: centos.mirrors.tds.net
 * epel: mirror.steadfast.net
 * extras: centos.mirrors.tds.net
 * updates: mirror.steadfast.net
pgdg90-source/primary_db                               |  19 kB     00:00
http://yum.pgrpms.org/srpms/9.0/redhat/rhel-5-x86_64/repodata/primary.sqlite.bz2: [Errno -3] Error performing checksum
Trying other mirror.
Error: failure: repodata/primary.sqlite.bz2 from pgdg90-source: [Errno 256] No more mirrors to try.

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!