Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!

Click here to return to the '10.7: Updating Lion Server if using CalDAV and CardDAV' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
10.7: Updating Lion Server if using CalDAV and CardDAV
Authored by: alexiskai on Feb 06, '12 10:13:42AM
This is a good time to point out that you can - and should - back up your 10.7 Server PostgreSQL databases independently of Time Machine. iCal, Address Book, and Wiki services all use PostgreSQL DBs to store their data. This means they need to have periodic DB dumps done, just like any other live DB. You can use the built-in postgres tools to automate this for you. For example, here's a crontab line you can use to back up the wiki DB:

PGUSER=_postgres /usr/bin/pg_dump -U _postgres collab -Fc -f /Library/Server/PostgreSQL/Backup/collab.sql > /dev/null 2>&1

This will dump the "collab" DB to file collab.sql in the Backup folder. You can repeat this for the other DBs. Use crontab to set backup frequency and type; you can also add other lines to control backup renaming and grooming, offsite copying, etc. I don't know the names of the iCal and CardDAV DBs offhand, but you can probably look them up, or maybe someone else here knows.

Edit: BTW, that's the root crontab I'm referring to.
Edited on Feb 06, '12 10:15:34AM by alexiskai

[ Reply to This | # ]