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