On Wed, Sep 2, 2015 at 4:15 PM, Bruce Momjian <bruce@momjian.us> wrote:
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.
