Re: Pg_upgrade remote copy - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Pg_upgrade remote copy
Date
Msg-id 20150902231539.GC23640@momjian.us
Whole thread Raw
In response to Re: Pg_upgrade remote copy  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: Pg_upgrade remote copy  (AI Rumman <rummandba@gmail.com>)
List pgsql-hackers
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. +



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Horizontal scalability/sharding
Next
From: Tomas Vondra
Date:
Subject: Re: DBT-3 with SF=20 got failed