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.
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. |