Re: pg_ctl reload - is it safe? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: pg_ctl reload - is it safe?
Date
Msg-id 200310142002.h9EK2m725847@candle.pha.pa.us
Whole thread Raw
In response to Re: pg_ctl reload - is it safe?  ("scott.marlowe" <scott.marlowe@ihs.com>)
List 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 by date:

Previous
From: James Rogers
Date:
Subject: Re: Database Kernels and O_DIRECT
Next
From: Neil Conway
Date:
Subject: Re: postgres --help-config