Re: How do I set up automatic backups? - Mailing list pgsql-general

From Tomasz Ostrowski
Subject Re: How do I set up automatic backups?
Date
Msg-id 48901DD9.2000007@batory.org.pl
Whole thread Raw
In response to Re: How do I set up automatic backups?  ("John Cheng" <chonger.cheng@gmail.com>)
Responses Re: How do I set up automatic backups?
List pgsql-general
On 2008-07-29 23:47, John Cheng wrote:
> Slony-I replication is also a viable choice for backups.

No, it's not. Redundancy is not a substitute for backups. Slony will not
help you if you do by mistake "delete from important_table" - as a copy
will also have all rows deleted.

For backups I'd recommend for example pg_dump and duplicity run from cron.

Regards
Tometzky
--
...although Eating Honey was a very good thing to do, there was a
moment just before you began to eat it which was better than when you
were...
                                                      Winnie the Pooh

pgsql-general by date:

Previous
From: Christophe
Date:
Subject: Re: Cursor
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: How do I set up automatic backups?