On Mon, Mar 16, 2009 at 11:15 PM, Nagalingam, Karthikeyan <KARTHIKEYAN.Nagalingam@xxxxxxxxxx> wrote: > Thanks Stefan for all your answers. My last question is "What is the > Mostly used Disaster Recovery Solution for Postgresql in storage > environment." We use two methods of backup to keep the database afloat amid things going horribly wrong. We have 1 or more slony backup dbs that allow for failover and load balancing. We have offsite pg_dump backups which are transferred via ssh to an offsite server in case of catastrophic failure in the data center (like a huge power surge) that kills both servers. We routinely restore backup sets or parts of them for various testing scenarios. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
