<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<font size="+1"><font face="Georgia">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.<br>
<br>
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):<br>
<br>
</font></font><font size="+1"><tt># uname -a<br>
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<br>
</tt></font><font size="+1"><font face="Georgia"><br>
<br>
And here's my repositories:<br>
<br>
</font></font><font size="+1"><tt># yum repolist<br>
Loaded plugins: allowdowngrade, changelog, downloadonly,
fastestmirror<br>
Loading mirror speeds from cached hostfile<br>
* base: mirror.nwresd.org<br>
* epel: mirror.steadfast.net<br>
* extras: centos-distro.cavecreek.net<br>
* updates: mirror.steadfast.net<br>
pgdg90-source/primary_db | 19
kB 00:00<br>
<a class="moz-txt-link-freetext" href="http://yum.pgrpms.org/srpms/9.0/redhat/rhel-5-x86_64/repodata/primary.sqlite.bz2:">http://yum.pgrpms.org/srpms/9.0/redhat/rhel-5-x86_64/repodata/primary.sqlite.bz2:</a>
[Errno -3] Error performing checksum<br>
Trying other mirror.<br>
repo id repo
name status<br>
base CentOS-5 -
Base 3,566<br>
elgis EL GIS 5 -
x86_64 136<br>
epel Extra Packages for Enterprise Linux 5 -
x86_64 6,730<br>
extras CentOS-5 -
Extras 235<br>
pgdg90 PostgreSQL 9.0 5 -
x86_64 132<br>
pgdg90-source PostgreSQL 9.0 5 - x86_64 -
Source 0<br>
updates CentOS-5 -
Updates 0<br>
repolist: 10,799<br>
</tt></font><font size="+1"><font face="Georgia"><br>
I first tried to downgrade postgres90 (9.0.5) but got this:<br>
<br>
# yum downgrade postgresql90<br>
</font></font><font size="+1"><tt>Loaded plugins: allowdowngrade,
changelog, downloadonly, fastestmirror<br>
Setting up Downgrade Process<br>
Loading mirror speeds from cached hostfile<br>
* base: centos.mirrors.tds.net<br>
* epel: mirror.steadfast.net<br>
* extras: centos.mirrors.tds.net<br>
* updates: mirror.steadfast.net<br>
pgdg90-source/primary_db | 19
kB 00:00<br>
<a class="moz-txt-link-freetext" href="http://yum.pgrpms.org/srpms/9.0/redhat/rhel-5-x86_64/repodata/primary.sqlite.bz2:">http://yum.pgrpms.org/srpms/9.0/redhat/rhel-5-x86_64/repodata/primary.sqlite.bz2:</a>
[Errno -3] Error performing checksum<br>
Trying other mirror.<br>
Error: failure: repodata/primary.sqlite.bz2 from pgdg90-source:
[Errno 256] No more mirrors to try.<br>
</tt></font><font size="+1"><font face="Georgia"><br>
Then I tried just getting rid of postgres and reinstalling. But
I didn't get far.<br>
<br>
</font></font><font size="+1"><tt># yum remove postgres90<br>
</tt></font><font size="+1"><tt>Loaded plugins: allowdowngrade,
changelog, downloadonly, fastestmirror<br>
Setting up Remove Process<br>
No Match for argument: postgres90<br>
Loading mirror speeds from cached hostfile<br>
* base: centos.mirrors.tds.net<br>
* epel: mirror.steadfast.net<br>
* extras: centos.mirrors.tds.net<br>
* updates: mirror.steadfast.net<br>
pgdg90-source/primary_db | 19
kB 00:00<br>
<a class="moz-txt-link-freetext" href="http://yum.pgrpms.org/srpms/9.0/redhat/rhel-5-x86_64/repodata/primary.sqlite.bz2:">http://yum.pgrpms.org/srpms/9.0/redhat/rhel-5-x86_64/repodata/primary.sqlite.bz2:</a>
[Errno -3] Error performing checksum<br>
Trying other mirror.<br>
Error: failure: repodata/primary.sqlite.bz2 from pgdg90-source:
[Errno 256] No more mirrors to try.<br>
</tt></font><font size="+1"><font face="Georgia"><br>
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? <br>
<br>
Thanks in advance; I really appreciate all your help!<br>
<br>
<br>
</font></font>
</body>
</html>