Re: Need Urgent Help in case of postgres Database Crash. - Mailing list pgsql-admin

From scott.marlowe
Subject Re: Need Urgent Help in case of postgres Database Crash.
Date
Msg-id Pine.LNX.4.33.0310060927380.8744-100000@css120.ihs.com
Whole thread Raw
In response to Re: Need Urgent Help in case of postgres Database Crash.  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-admin
On Mon, 6 Oct 2003, Bruno Wolff III wrote:

> On Mon, Oct 06, 2003 at 12:28:49 +0530,
>   Somasekhar Bangalore <sbangalore@zensutra.com> wrote:
> > 1. Steps needed to setup the postgres database  , is it posssible for me to write data on to two different disks.
ifso how? 
> >
> > 2. Steps needed  to recover the data in case of database crash or hardware crash.
>
> If the disks don't get clobbered, you can just restart the server and you
> should get back all committed transactions. If you lose the disks (or
> commit an undesired transaction), then you will need to go back to the point
> of your last backup.

If you're using IDE drives, make sure and turn off write caching,
otherwise all bets are off as regards data integrity.  on linux it's
'hdparm -W0 /dev/hdx' where x is replaced by the drive letter of choice.


pgsql-admin by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Need Urgent Help in case of postgres Database Crash.
Next
From: Gaetano Mendola
Date:
Subject: pg_autovacuum questions