Re: Streaming base backups

On Sat, Jan 15, 2011 at 8:33 PM, Tatsuo Ishii <ishii@postgresql.org> wrote:
>> When do the standby launch its walreceiver? It would be extra-nice for
>> the base backup tool to optionally continue streaming WALs until the
>> standby starts doing it itself, so that wal_keep_segments is really
>> deprecated.  No idea how feasible that is, though.
>
> Good point. I have been always wondering why we can't use exiting WAL
> transporting infrastructure for sending/receiving WAL archive
> segments in streaming replication.
> If my memory serves, Fujii has already proposed such an idea but was
> rejected for some reason I don't understand.

I must be confused, because you can use backup_command/restore_command
to transport WAL segments, in conjunction with streaming replication.

What Fujii-san unsuccessfully proposed was to have the master restore
segments from the archive and stream them to clients, on request.  It
was deemed better to have the slave obtain them from the archive
directly.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company