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.
> pg_upgrade isn't reliable enough, and using pglogical means you need a
> second machine. Maybe everybody should run with a standby, but not
> everyone does.
I don't see why you can't have the pg_logical slave be on the same
server as the master for an upgrade. It will double the write volume
while it is active, but assuming it is setup only to perform a major
version upgrade, it should be fine.
--
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 +
