Tuesday, November 27, 2012

Getting access to iCal Server database

On Mac OS X Server 10.7 and 10.8, the data for the iCal and Address Book services is located inside a PostgreSQL database. If you wish to see the data in the database, you can connect to the database by logging with SSH on the server, and call:
sudo psql -U _postgres caldav
All iCalendar objects are in the calendar_object table, and all vCard objects are in the addressbook_object table.

 If you wish to delete the data because you are not using the services anymore, call:
sudo dropdb -U caldav caldav

No comments:

Post a Comment