> > 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
