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.