On Mon, Jan 17, 2011 at 11:32 AM, Tatsuo Ishii <is...@postgresql.org> wrote: >>> 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. > > Yes, but using restore_command is not terribly convenient. On > Linux/UNIX systems you have to enable ssh access, which is extremely > hard on Windows.
Agreed. > IMO Streaming replication is not yet easy enough to set up for > ordinary users. It is already proposed that making base backup easier > and I think it's good. Why don't we go step beyond a little bit more? > >> 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. > > Did Fuji-san agreed on the conclusion? No. If the conclusion is true, we would not need a streaming backup feature. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers