Re: RH 9 upgrade

From: Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
To: rwhart(at)netexpress(dot)net, pgsql-admin(at)postgresql(dot)org
Subject: Re: RH 9 upgrade
Date: 2003-05-01 22:38:53
Message-ID: 200305011838.53131.lamar.owen@wgcr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thursday 01 May 2003 17:34, Bob Hartung wrote:
> I had just begun to learn postgres when RH9 was released. Today, I
> upgraded and now postmaster won't start. I did not do a data dump prior to
> the upgrade. Is there a way to recover my learning tables or do I just
> chalk this up to experience?

> I did not see much useful info. in the README-rpm file installed in the
> upgrade.

Install (using --oldpackage) the 7.2.4 RPMset from ftp.postgresql.org (it's in
/pub/binary/v7.2.4/redhat-9 ). Dump your data; stop postmaster; copy the
/var/lib/pgsql/data tree somewhere; wipe said tree; install the 7.3.2 RPMs
that shipped with RHL9, the restart postmaster.

Upgrading a major version of PostgreSQL is a major pain.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Hacksaw 2003-05-01 23:35:15 Re: Impact of loss of unique SERIAL?
Previous Message Björn Metzdorf 2003-05-01 22:28:51 Re: The database system is in recovery mode