Re: PG quitting sporadically!! - Mailing list pgsql-general

From Douglas McNaught
Subject Re: PG quitting sporadically!!
Date
Msg-id 5ded07e00802141658i5152437ewcb1fa0328c2253a6@mail.gmail.com
Whole thread Raw
In response to Re: PG quitting sporadically!!  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
List pgsql-general
>  > 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

pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: character conversion problem about UTF-8-->SHIFT_JIS_2004
Next
From: Joe Conway
Date:
Subject: Re: dynamic crosstab