[ELGIS] Untangling pgdg postgresql90 from Centos and ELGIS

[Bill Thoen]

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!


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/el/attachments/20111004/cc2016e2/attachment.html