Re: WAL logs multiplexing?

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: WAL logs multiplexing?
Дата
Msg-id 20051228123814.GD24400@svana.org
обсуждение исходный текст
Ответ на WAL logs multiplexing?  (Dmitry Panov <dmitry@tsu.tula.ru>)
Ответы Re: WAL logs multiplexing?  (Dmitry Panov <dmitry@tsu.tula.ru>)
Re: WAL logs multiplexing?  (Trent Shipley <tshipley@deru.com>)
Список pgsql-general
On Wed, Dec 28, 2005 at 03:17:40PM +0300, Dmitry Panov wrote:
> I'm currently considering setting up online backup procedure and I
> thought maybe it would be a useful feature if the online logs could be
> written into more than one place (something like oracle redo logs
> multiplexing).
>
> If I got it right if the server's filesystem crashes completely then the
> changes that haven't gone into an archived log will be lost. If the logs
> are written into more than one place the loss could be minimal.

So you think PostgreSQL should reimplement something that RAID
controllers already do better?

These are reasons you have backups and PITR and other such things. I
don't think having the server log to multiple places really gains you
anything...

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Вложения

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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Automatic recovery process
Следующее
От: Vilen Tambovtsev
Дата:
Сообщение: DB crash after disk full