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 day

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 r

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 i

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 recom

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 t

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. >>http:

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 ( *ni

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 PgAdmi

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 chang

[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 s