Re: Upgrading on RH72

Patrick Nelson dijo:

> Finally realized that the problems that I'm having are because my server is
> RH72 running server 7.1.3-2 and my clients are RH73 running 7.2.1-5 and the
> clients don't seem backward compatible.  So I thought I would upgrade the
> server to RH73... OK that's not going to work.  So I grabbed the latest 72
> rpms from a PostgreSQL mirror which have the version that looks like
> 7.2.1-2, so this should work.  Anyone have success with this?  I think it
> said something about having to initdb...  what does this mean?

It means you'll have to dump your database using pg_dump (of the 7.1.3
version currently installed), then upgrade (rpm -U postgresql-7.2.1),
then restore the dump (by means of psql < dump, or using pg_restore).
Be sure to read the manpages for pg_dump and pg_restore if you haven't
done so.

BTW, the PGDG RPMs should take care of the upgrading process
automatically, but there are always pitfalls so you may as well be
careful.

> What does the PGDG stand for in the filename (i.e.
> postgresql-7.2.1-2PGDG.i386.rpm)?

"PostegreSQL Global Development Group", as opposed to the RPMs built by
RedHat, Mandrake, etc.

--
Alvaro Herrera (<alvherre[a]atentus.com>)
"La tristeza es un muro entre dos jardines" (Khalil Gibran)