Re: 7.0 -> 7.2 Migration (oops)

It seems as though it would be easiest to work outside of the package system
at this point, unless your not really familiar with compiling/installing
software from source. Supplying --no-deps to rpm seems dangerous to me,
although perhaps Lamar's directions are known to be safe enough.

Download postgres 7.0 source, compile & install it in it's own new directory
(so that it doesn't clutter up your system later) and on it's own port. Point
the postmaster to the old "PGDATA" directory and do pg_dump. After you've got
the dump, shut the 7.0 postmaster down, move the old PGDATA directory to some
backup location (just in case), and create an empty directory in place of the
PGDATA you just moved. Then, initdb (with 7.2) the empty directory and
pg_restore.

Regards,
Jeff Davis

On Friday 27 September 2002 01:15 pm, Lamar Owen wrote:
> 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.