Re: Re: Synch Rep: direct transfer of WAL file from the primary to the standby - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Re: Synch Rep: direct transfer of WAL file from the primary to the standby
Date
Msg-id 4A55B4A3020000250002863A@gw.wicourts.gov
Whole thread Raw
In response to Re: Re: Synch Rep: direct transfer of WAL file from the primary to the standby  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: Re: Synch Rep: direct transfer of WAL file from the primary to the standby
List pgsql-hackers
Fujii Masao <masao.fujii@gmail.com> wrote: 
> Kevin Grittner<Kevin.Grittner@wicourts.gov> wrote:
>> I think the interesting bit is when you're at this point and the
>> connection between the master and slave goes down for a couple
>> days.  How do you handle that?
> 
> In the current design of synch rep, you have only to restart the
> standby after repairing the network.
How long does the interruption need to last to require manual
intervention?  Would an automated retry make sense?  (I'd bet that
more days than not we lose connectivity to at least one of our remote
sites for at least a few minutes.)
-Kevin


pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: *_collapse_limit, geqo_threshold - example schema
Next
From: Pavel Golub
Date:
Subject: Re: bytea vs. pg_dump