Re: Pg_upgrade remote copy - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Pg_upgrade remote copy
Date
Msg-id 20150829182827.GC28360@momjian.us
Whole thread Raw
In response to Pg_upgrade remote copy  (AI Rumman <rummandba@gmail.com>)
Responses Re: Pg_upgrade remote copy
List pgsql-hackers
On Fri, Aug 28, 2015 at 10:34:38PM -0700, AI Rumman wrote:
> Hi,
> 
> 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.
> We can add two parameters - oldhost and if it is used, pg_upgrade will identify
> the old host as remote and instead of local copy, it will use remote copy.
> 
> What do you think about it?

Well, you could NFS-mount the remote directory and have it work that
way.  One complexity is that you need to start/stop the old and new
servers, so doing something without NFS is going to be vary hard.

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.

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



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: On-demand running query plans using auto_explain and signals
Next
From: Jeff Janes
Date:
Subject: buffer README is out of date