Re: [GENERAL] How do I set up automatic backups?

2008-07-31 Thread pglists
I created this script sometime ago and it works fine for me and others.. Maybe it might work for you http://www.zeroaccess.org/postgresql-backup 1.0RC1 is pretty stable I have ran it for 3 weeks without any problems Quoting Rob Richardson [EMAIL PROTECTED]: Greetings again! A few days

Re: [GENERAL] How do I set up automatic backups?

2008-07-30 Thread Tomasz Ostrowski
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

Re: [GENERAL] How do I set up automatic backups?

2008-07-30 Thread hubert depesz lubaczewski
On Tue, Jul 29, 2008 at 04:24:08PM -0400, Rob Richardson wrote: him. The only answers I've found on the Internet involve creating a password-less account and using that to run pg_dump. What is the official best way to automatically back up a PostGres database? using pg_dump - yes. making

Re: [GENERAL] How do I set up automatic backups?

2008-07-30 Thread Craig Ringer
Tomasz Ostrowski wrote: 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

[GENERAL] How do I set up automatic backups?

2008-07-29 Thread Rob Richardson
Greetings again! A few days ago, I visited a customer's site to talk about administering our system, which is developed around a PostGres database. One of the topics was how to back up the database. I described the process of using PgAdmin to back up and restore a database, and I said a backup

Re: [GENERAL] How do I set up automatic backups?

2008-07-29 Thread Christophe
On Jul 29, 2008, at 1:24 PM, Rob Richardson wrote: I was asked how to automate the procedure, and I couldn't answer. The options are manifold! http://www.postgresql.org/docs/8.3/interactive/backup.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] How do I set up automatic backups?

2008-07-29 Thread Steve Atkins
On Jul 29, 2008, at 1:24 PM, Rob Richardson wrote: Greetings again! A few days ago, I visited a customer's site to talk about administering our system, which is developed around a PostGres database. One of the topics was how to back up the database. I described the process of using

Re: [GENERAL] How do I set up automatic backups?

2008-07-29 Thread Richard Broersma
On Tue, Jul 29, 2008 at 1:28 PM, Christophe [EMAIL PROTECTED] wrote: I was asked how to automate the procedure, and I couldn't answer. http://www.postgresql.org/docs/8.3/interactive/backup.html Regarding the SQL backup option for small databases, I use an OS task scheduler ( *nix

Re: [GENERAL] How do I set up automatic backups?

2008-07-29 Thread John Cheng
Slony-I replication is also a viable choice for backups. On Tue, Jul 29, 2008 at 1:34 PM, Richard Broersma [EMAIL PROTECTED] wrote: On Tue, Jul 29, 2008 at 1:28 PM, Christophe [EMAIL PROTECTED] wrote: I was asked how to automate the procedure, and I couldn't answer.

Re: [GENERAL] How do I set up automatic backups?

2008-07-29 Thread Scott Marlowe
On Tue, Jul 29, 2008 at 2:24 PM, Rob Richardson [EMAIL PROTECTED] wrote: Greetings again! A few days ago, I visited a customer's site to talk about administering our system, which is developed around a PostGres database. One of the topics was how to back up the database. I described the