| From: | Sam Barnett-Cormack <s(dot)barnett-cormack(at)lancaster(dot)ac(dot)uk> |
|---|---|
| To: | Somasekhar Bangalore <sbangalore(at)zensutra(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Need Urgent Help in case of postgres Database Crash. |
| Date: | 2003-10-06 10:48:26 |
| Message-ID: | Pine.LNX.4.50.0310061147360.24521-100000@short.lancs.ac.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, 6 Oct 2003, Somasekhar Bangalore wrote:
> Hi ,
>
> I am setting up a postgres 7.3 database for a big client.I don't want to lose any data in case of database crash or hardware failure . I need help in
>
> 1. Steps needed to setup the postgres database , is it posssible for me to write data on to two different disks. if so how?
For data redundancy, I reccomend RAID level 0 or 5 - 5 is vastly
superior, if you can afford it.
> 2. Steps needed to recover the data in case of database crash or hardware crash.
Keep regular backups with pg_dump
--
Sam Barnett-Cormack
Software Developer | Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sam Barnett-Cormack | 2003-10-06 10:56:10 | Re: Need Urgent Help in case of postgres Database Crash. |
| Previous Message | Somasekhar Bangalore | 2003-10-06 06:58:49 | Need Urgent Help in case of postgres Database Crash. |