Re: Pg_upgrade remote copy

On Wed, Sep  2, 2015 at 04:50:32PM -0300, Alvaro Herrera wrote:
> Bruce Momjian wrote:
> > On Fri, Aug 28, 2015 at 10:34:38PM -0700, AI Rumman wrote:
> 
> > > In pg_upgrade, how about adding a feature to copy data directory over network.
> > > That is, we can run pg_upgrade from our new host, where old host will be a
> > > remote machine.
> 
> > I think it is much simpler to just copy the old clsuter to the remote
> > server and run pg_upgrade in --link mode on the remote server.
> 
> Couldn't it run pg_basebackup as a first step?

Yes.  I was thinking it would be simpler to just shut down the server
and copy it, but pg_basebackup would allow the server to be up during
the copy.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + Everyone has their own god. +