Re: 7.0 -> 7.2 Migration (oops)

On Friday 27 September 2002 09:46 am, Glen Baker wrote:
> Whups...I just upgraded my linux system from Redhat 7.1 to 7.3. As a part
> of that upgrade my postgres installation was also upgraded from 7.0 to
> 7.2.1.

> Is there any way that I can migrate the databases after the fact? Had I
> realized this was going to happen I would have dumped them beforehand, but
> it's a bit late now..

It's mentioned in the Red Hat 7.3 release notes.

Anyway, that doesn't help you.  You _might_ be able to reinstall your
PostgreSQL 7.0 RPM's from your Red Hat 7.1 install media.  Get all the
postgresql rpm's you have installed off the install media, and put them
somewhere (I use /root/install as a holding bin for updated and downgraded
RPMs) and make sure those are the only RPMs in that directory.

Now, you can try:
rpm -Uvh --nodeps --oldpackage postgresql*.rpm

and see what happens.  It _should_ work, even though you will get warnings.

Restart postmaster (/sbin/service postgresql start), dump, stop postmaster,
then rpm -Uvh to the PostgreSQL RPMs you got with Red Hat 7.3.  Then move
your old data tree somewhere else, and start the new postmaster.  You should
be able to restore into it, although some hand-editing of the dumpfile may be
required.

And next time read the release notes... :-)  Anyway, I certainly feel your
pain -- I got caught the same way between Red Hat 5.0 and Red Hat 5.1.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11