Re: Multiple backends on a single physical database

Поиск
Список
Период
Сортировка
От Ragnar Kjørstad
Тема Re: Multiple backends on a single physical database
Дата
Msg-id 20021012183424.M14731@vestdata.no
обсуждение исходный текст
Ответ на Re: Multiple backends on a single physical database  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Multiple backends on a single physical database  (Jeff <threshar@torgo.978.org>)
Список pgsql-admin
On Sat, Oct 12, 2002 at 12:26:51PM -0400, Tom Lane wrote:
> Load testing is not the issue here; crash testing is.  Try pulling the
> power plug on your NFS box while the database is under load.  If you
> can do that repeatedly and not suffer database corruption, then maybe
> you have a safe setup.  Be sure to try the case of NFS crash immediately
> after a CHECKPOINT.


If pulling the plug causes database-corruption that proves that there is
something wrong with NFS-setup, but if it _doesn't_ cause
database-corruption that doesn't prove that it's safe - it could be that
you're just lucky.

This should be obvious, but I've seen too many people argument like
"I've tested it twice and it didn't break so it must be safe".



--
Ragnar Kjørstad
Big Storage

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

Предыдущее
От: Ragnar Kjørstad
Дата:
Сообщение: Re: Multiple backends on a single physical database
Следующее
От: "Gaetano Mendola"
Дата:
Сообщение: Statistic collector too many fork