Re: Data Corruption in case of abrupt failure

From: "Rod K" <rod(at)23net(dot)net>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Keith C(dot) Perry" <netadmin(at)vcsn(dot)com>, "Stephen Robert Norris" <srn(at)commsecure(dot)com(dot)au>, "satish satish" <satish_ach2003(at)yahoo(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Data Corruption in case of abrupt failure
Date: 2004-03-17 18:07:15
Message-ID: KNEPILBLIADCDMMPIKIKOEDPFBAA.rod@23net.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Does anyone know the equivalent to hdparm on FreeBSD?

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of scott.marlowe
> Sent: Wednesday, March 17, 2004 11:27 AM
> To: Tom Lane
> Cc: Keith C. Perry; Stephen Robert Norris; satish satish;
> pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Data Corruption in case of abrupt failure
>
>
> On Tue, 16 Mar 2004, Tom Lane wrote:
>
> > "Keith C. Perry" <netadmin(at)vcsn(dot)com> writes:
> > > I've read threads like this before and because I've never lost data on
> > > servers with IDE drives after doing some basic torture tests
> > > (e.g. pulling the plug in the middle of an update et al), I don't
> > > think I've paid close enough attention.
> >
> > On many IDE drives it is possible to turn write caching on and off with
> > some incantation involving "hdparm" (don't have the details but you can
> > probably find 'em in the list archives). Possibly your system is
> > already configured safely.
>
> hdparm -W0 /dev/hda
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-03-17 18:09:08 Re: Check constraint
Previous Message Valter 2004-03-17 17:52:34 Relation "xxxxx" does not exist