Re: Pg_upgrade remote copy - Mailing list pgsql-hackers

From AI Rumman
Subject Re: Pg_upgrade remote copy
Date
Msg-id CAGoODpdqJiGTq7Lz-=OvBQCJ9k8zaxeoNqN8oG4fM4PW4+tzCA@mail.gmail.com
Whole thread Raw
In response to Re: Pg_upgrade remote copy  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
<div dir="ltr">Thanks for the solution.</div><div class="gmail_extra"><br /><div class="gmail_quote">On Wed, Sep 2,
2015at 4:15 PM, Bruce Momjian <span dir="ltr"><<a href="mailto:bruce@momjian.us"
target="_blank">bruce@momjian.us</a>></span>wrote:<br /><blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px#ccc solid;padding-left:1ex"><span class="">On Wed, Sep  2, 2015 at 04:50:32PM -0300, Alvaro
Herrerawrote:<br /> > Bruce Momjian wrote:<br /> > > On Fri, Aug 28, 2015 at 10:34:38PM -0700, AI Rumman
wrote:<br/> ><br /> > > > In pg_upgrade, how about adding a feature to copy data directory over network.<br
/>> > > That is, we can run pg_upgrade from our new host, where old host will be a<br /> > > > remote
machine.<br/> ><br /> > > I think it is much simpler to just copy the old clsuter to the remote<br /> >
>server and run pg_upgrade in --link mode on the remote server.<br /> ><br /> > Couldn't it run pg_basebackup
asa first step?<br /><br /></span>Yes.  I was thinking it would be simpler to just shut down the server<br /> and copy
it,but pg_basebackup would allow the server to be up during<br /> the copy.<br /><div class="HOEnZb"><div
class="h5"><br/> --<br />   Bruce Momjian  <<a href="mailto:bruce@momjian.us">bruce@momjian.us</a>>        <a
href="http://momjian.us"rel="noreferrer" target="_blank">http://momjian.us</a><br />   EnterpriseDB                   
        <a href="http://enterprisedb.com" rel="noreferrer" target="_blank">http://enterprisedb.com</a><br /><br />   +
Everyonehas their own god. +<br /></div></div></blockquote></div><br /></div> 

pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Failing assertions in indxpath.c, placeholder.c and brin_minmax.c
Next
From: Tom Lane
Date:
Subject: Re: pg_ctl/pg_rewind tests vs. slow AIX buildfarm members