On Mon, 6 Oct 2003, Bruno Wolff III wrote: > On Mon, Oct 06, 2003 at 12:28:49 +0530, > Somasekhar Bangalore <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
