Thanks all for your help. I installed from the RPM, found the sources (although it wasn't obvious), rebuilt the identical version that i had before and I am up and running.
Still, I consider automatic yum updates for Postgres fundamentally broken, if they invalidate your database directory. A 2 minute update may cost an hour of downtime for someone who is not expecting this, like I wasn't.
I have been installing postgres manually in /usr/local/postgres-<version>/ on all other machines, but on this machine I got lazy. Well now I know :)
Thanks all for good advice.
K
On Jun 15, 2009, at 9:56 PM, Devrim GÜNDÜZ wrote:
On Mon, 2009-06-15 at 22:10 -0600, Scott Marlowe wrote:
Got a backup of the original 8.4devel_20090310-1PGDG.rhel5.i386
package? I'd think reinstalling that would fix your problen.
Unfortunately I removed binary -devel packages from the repository.
However, SRPM do exist:
http://yum.pgsqlrpms.org/srpms/8.4/redhat/rhel-5-i386/postgresql-8.4devel_20090310-1PGDG.rhel5.src.rpmYou can build them in your platform, and as Scott said, install them,
backup old data and then update to RC1.
Regards,
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org
___
Konstantin Gredeskoul
CTO and Co-Founder
Mobile Application Development and Hosting
Office Number: +1 (650) 355 4700