On Fri, Dec 05, 2014 at 22:57:50 -0800,
"M. Edward (Ed) Borasky" <znmeb(a)znmeb.net> wrote:
I thought PostgreSQL fixed that a couple of years ago - "upgrade in
place" was the most-requested feature for a long time. But I can see
why DBAs wouldn't trust it after having mastered the
dump-upgrade-restore process.
That makes the upgrade easier to do, but you still need to have a backup
plan if the upgrade in place fails. In addition you need to worry about changes
breaking your configuration or applications.