Re: Backup history file should be replicated in Streaming Replication?

Поиск
Список
Период
Сортировка
От Aidan Van Dyk
Тема Re: Backup history file should be replicated in Streaming Replication?
Дата
Msg-id 20091222211715.GI6312@oak.highrise.ca
обсуждение исходный текст
Ответ на Re: Backup history file should be replicated in Streaming Replication?  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-hackers
* Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> [091222 15:47]:

> I was just having a chat with Magnus this morning, and he asked if the
> current patch already provides or if it would be possible to write a
> stand-alone utility to connect to a master and stream WAL files to an
> archive directory, without setting up a full-blown standby instance. We
> came to the conclusion that backup history files wouldn't be copied as
> the patch stands, because the standby has to specifically request them.

Please, please, please...

I've been watching the SR from the sidelines, basically because I want
my WAL fsync'ed on 2 physically separate machines before the client's
COMMIt returns...

And no, I'm not really interested in trying to do raid over NBD or DRBD,
and deal with the problems and pitfals that entails...

Being able to write a utility that connects as an "SR" client, but just
synchronously writes WAL into an archive directory setup is exactly what
I want...  And once SR has settled, it's something I'm interested in
working on...

a.

-- 
Aidan Van Dyk                                             Create like a god,
aidan@highrise.ca                                       command like a king,
http://www.highrise.ca/                                   work like a slave.

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Backup history file should be replicated in Streaming Replication?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: LIKE INCLUDING COMMENTS code is a flight of fancy