Re: Streaming base backups - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: Streaming base backups
Date
Msg-id 20110117.113232.773489322414041114.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: Streaming base backups  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Streaming base backups  (Fujii Masao <masao.fujii@gmail.com>)
Re: Streaming base backups  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
>> 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.

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?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Warning compiling pg_dump (MinGW, Windows XP)
Next
From: Fujii Masao
Date:
Subject: Re: Streaming base backups