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

From Tom Lane
Subject Re: Re: Synch Rep: direct transfer of WAL file from the primary to the standby
Date
Msg-id 28650.1247002411@sss.pgh.pa.us
Whole thread Raw
In response to Re: Re: Synch Rep: direct transfer of WAL file from the primary to the standby  (Dimitri Fontaine <dfontaine@hi-media.com>)
Responses Re: Re: Synch Rep: direct transfer of WAL file from the primary to the standby
List pgsql-hackers
Dimitri Fontaine <dfontaine@hi-media.com> writes:
> Could we add yet another postmaster specialized child to handle the  
> archive, which would be like a default archive_command implemented in  
> core.

I think this fails the basic sanity check: do you need it to still work
when the master is dead.  It's reasonable to ask the master to supply a
few gigs of very-recent WAL, but as soon as the word "archive" enters
the conversation, you should be thinking in terms of a different
machine.  Or at least a design that easily scales to put the archive on
a different machine.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Sergey Burladyan
Date:
Subject: Re: 8.4, One-Time Filter and subquery ( ... FROM function() union all ... )
Next
From: Tom Lane
Date:
Subject: Re: *_collapse_limit, geqo_threshold