Re: Streaming base backups

Поиск
Список
Период
Сортировка
От Tatsuo Ishii
Тема Re: Streaming base backups
Дата
Msg-id 20110117.113232.773489322414041114.t-ishii@sraoss.co.jp
обсуждение исходный текст
Ответ на Re: Streaming base backups  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Streaming base backups  (Fujii Masao <masao.fujii@gmail.com>)
Re: Streaming base backups  (Magnus Hagander <magnus@hagander.net>)
Список 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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Warning compiling pg_dump (MinGW, Windows XP)
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: Streaming base backups