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.
...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
Winnie the Pooh
In response to
pgsql-general by date
|Next:||From: hubert depesz lubaczewski||Date: 2008-07-30 08:01:10|
|Subject: Re: How do I set up automatic backups?|
|Previous:||From: Christophe||Date: 2008-07-29 23:56:47|
|Subject: Re: Cursor|