On 7/7/16 8:17 PM, Simon Riggs wrote:
Simplicity is key, I agree. But that's just a user interface feature, not a comment on what's underneath the covers. pg_upgrade is not simple and is never likely to be so, under the covers.
Right, and what I'd prefer effort put into is making managing replication in all forms easier. Replication has a lot of uses outside of upgrades.
FWIW, I've actually never used pg_upgrade because I view it as high-risk for the environments I've dealt with. There's no ability to fall back to the old version without losing data, and because of it's binary nature the odds of some kind of a corruption event happening are far higher than with something like londiste. Certainly many environments don't have those concerns though. Having options are good.
-- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com 855-TREBLE2 (855-873-2532) mobile: 512-569-9461 -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers