On Thu, May 12, 2016 at 10:37:28AM -0400, Robert Haas wrote:
> 3. I think we need to replace pg_upgrade with a real in-place upgrade
> scheme so that you just fire up the new version of the server on your
> old data directory, and it rejiggers things in place without needing
> to create a new cluster and migrate stuff over to it. I think that
> actually making this work is a huge engineering effort, and I have no
> plans to undertake it in the near term, but I think it has to be done.
Also, let me add that I smile every time pg_upgrade breaks and the fix is
in pg_dump because it allows me to avoid the problem. :-)
I am afraid that not relying on pg_dump is going to cause a lot of
maintenance work for every server change --- right now, only pg_dump
needs to be adjusted. So, the issue is not only getting in-place
upgrade to work, but the future maintenance of keeping it working.
OK, I will stop smiling now. ;-)
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +