Re: Need Urgent Help in case of postgres Database Crash.

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: Somasekhar Bangalore <sbangalore(at)zensutra(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Need Urgent Help in case of postgres Database Crash.
Date: 2003-10-06 15:28:34
Message-ID: Pine.LNX.4.33.0310060927380.8744-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, 6 Oct 2003, Bruno Wolff III wrote:

> On Mon, Oct 06, 2003 at 12:28:49 +0530,
> Somasekhar Bangalore <sbangalore(at)zensutra(dot)com> wrote:
> > 1. Steps needed to setup the postgres database , is it posssible for me to write data on to two different disks. if so 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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Gaetano Mendola 2003-10-06 17:27:27 pg_autovacuum questions
Previous Message Bruno Wolff III 2003-10-06 13:45:54 Re: Need Urgent Help in case of postgres Database Crash.