Re: pg_ctl reload - is it safe?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: pg_ctl reload - is it safe?
Дата
Msg-id 200310142002.h9EK2m725847@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: pg_ctl reload - is it safe?  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-hackers
wscott.marlowe wrote:
> > If you use "intr" then this type of thing can happen. Lots of programs assume
> > the unix semantics for disk accesses. You can get all kinds of bugs when
> > they're violated.
> > 
> > If you use "soft" then the consequences can be much much worse. If your
> > fileserver were to reboot you could silently lose disk writes corrupting your
> > database.
> 
> What if the WAL was local on disk, and the data was going to nfs storage, 
> would that be safe, or saferer?  :-)

Not sure --- we do a sync() on the entire machine before recycling the WAL logs.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


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

Предыдущее
От: James Rogers
Дата:
Сообщение: Re: Database Kernels and O_DIRECT
Следующее
От: Neil Conway
Дата:
Сообщение: Re: postgres --help-config