Forum OpenACS Q&A: Enabling database-backup

Collapse
1: Enabling database-backup
Posted by C. R. Oldham on 05/20/04 08:35 PM
Greetings,

Sorry if I am being dense.  I note in the latest 5.1 there is a new directory called 'database-backup'.  Does that imply that there is some sort of automatic pg_dump facility available now?  How do I enable it?

Collapse
2: Re: Enabling database-backup (response to 1)
Posted by Jade Rubick on 05/20/04 09:51 PM
There is a backup script you can run. I believe this is in the documentation. It's a nice script, so check it out. There's also uptime monitoring (keepalive) -- very nice.
Collapse
3: Re: Enabling database-backup (response to 1)
Posted by Randy O'Meara on 05/21/04 03:57 AM
CR,

Check the backup script carefully. There are some typos.

Customize it for your service name/location. The script will (if I recall) dump your DB, tar your service directory (including DB dump), and copy it off to an external machine, naming the tar uniquely by service name and date. It performs a periodic full backup and daily incrementals (of course the DB is full daily dump).

/R