Backing up Calendars and Profile Manager in Mavericks 10.9 Server (v3)

Once again Apple have played around with the locations of the Postgres databases that make up the backend of Calendar Server (caldav) and ProfileManager (_devicemgr).

They now reside in separate databases (my guess is this is to make each service fully independant of each other).  Thankfully they can still be backed up using PG_DUMP and PG_DUMPALL.

As of Server v3, you can use the following commands to connect to the relevant unix socket paths and perform backups either as pgdump files that can be restored using pg_restore or as raw sql files (not sure why you would want the raw sql but hey ho), anyway here's the how to...

Don't forget to sudo or run as root...

Backup Calendar Server

	#Mavericks Calendar Backup
	#Dump whole Calendar DB as pgdump file suitable for use with PG_RESTORE
	/Applications/Server.app/Contents/ServerRoot/usr/bin/pg_dumpall -h /var/run/caldavd/PostgresSocket/ -U caldav -c -f $TARGETFOLDER.0/caldav_dumpall.pgdump
	#Dump Calendar table only as pgdump file suitable for use with PG_RESTORE
	/Applications/Server.app/Contents/ServerRoot/usr/bin/pg_dump -h /var/run/caldavd/PostgresSocket/ -U caldav caldav -c -f $TARGETFOLDER.0/caldav.sql
	#Dump Calendar table only as sql file.
	/Applications/Server.app/Contents/ServerRoot/usr/bin/pg_dump -h /var/run/caldavd/PostgresSocket/ -U caldav caldav -Fc -f $TARGETFOLDER.0/caldav.pgdump

view raw gistfile1.txt hosted with ❤ by GitHub

Backup Profile Manager

	#Mavericks Profile Manager Backup
	#Dump whole devicemgr DB as pgdump file suitable for use with PG_RESTORE
	/Applications/Server.app/Contents/ServerRoot/usr/bin/pg_dumpall -h /Library/Server/ProfileManager/Config/var/PostgreSQL/ -U _devicemgr -c -f $TARGETFOLDER.0/profilemanager_dumpall.pgdump
	#Dump devicemgr table only as pgdump file suitable for use with PG_RESTORE
	/Applications/Server.app/Contents/ServerRoot/usr/bin/pg_dump -h /Library/Server/ProfileManager/Config/var/PostgreSQL/ -U _devicemgr devicemgr_v2m0 -c -f $TARGETFOLDER.0/profilemanager.sql
	#Dump devicemgr table only as sql file.
	/Applications/Server.app/Contents/ServerRoot/usr/bin/pg_dump -h /Library/Server/ProfileManager/Config/var/PostgreSQL/ -U _devicemgr devicemgr_v2m0 -Fc -f $TARGETFOLDER.0/profilemanager.pgdump

view raw gistfile1.txt hosted with ❤ by GitHub

Good luck!