Re: PG quitting sporadically!!

> > Be aware that when 8.2.3 was released, 8.2 had only been out for two
> > months. There's another 11 months worth of accumulated bug fixes in
> > 8.2.6, including some that can cause the server to slow or crash. It's
> > not a difficult upgrade (no changes to the database) and you should
> > consider it. There are plenty of known and already fixed problems in
> > 8.2.3 you could be running into.
>
>
>
> Thanks, I can do that, but the upgrade process is not very simple or
> automated and will take backup of database and all that rigmarole.Last
> time I remember, I had to seek help from this forum to do that simple
> task, because something had gone remiss.
>
> Is there an easy RPM method of upgrading postgresql without
> backingup/restoring etc? I am on CentOS 4.

You don't need a dump/restore to go between minor releases (e.g. 8.2.3
to 8.2.6). Just install the new binaries and fire it up. Taking a
backup beforehand isn't a bad idea, of course. :)

-Doug