Re: Streaming base backups - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Streaming base backups
Date
Msg-id AANLkTinSzDXPjxWYmuw0jHGw2T6TjcNBJw6uSwu3DfmZ@mail.gmail.com
Whole thread Raw
In response to Re: Streaming base backups  (Tatsuo Ishii <ishii@postgresql.org>)
Responses Re: Streaming base backups
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Replication logging
Next
From: Robert Haas
Date:
Subject: Re: walreceiver fallback_application_name