Applications/Server.app/Contents/ServerRoot/usr/sbin/calendarserver_export -all -calendars -directory=/tmp/caldav_$TS/calendars Mkdir -p -m 700 /tmp/caldav_$TS/calendars # locate specific calendars with known eventsįind ~/Downloads/Library/Calendars -type f -name '*.ics' -exec fgrep -li keyword_to_search_for ' ' Rsync -a ~/Library/Application\ Support/AddressBook ~/Downloads/Library/Application\ Support/AddressBook/ Rsync -a ~/Library/Calendars/ ~/Downloads/Library/Calendars/ Mkdir -p ~/Downloads/Library/Application\ Support/AddressBook On each client and user account: make a copy of the raw Calendars and Contacts folders: mkdir -p ~/Downloads/Library/Calendars caldav.sqlĬonn = pg.connect("host='localhost' user='caldav' dbname='caldav'")Ĭur.execute('select * from calendar_object where calendar_resource_id = 1769 ')Ĭur.execute('select * from calendar_object ')Ĭlient(s): Backup and export per-user Calendar and Contacts Sudo -u _calendar /Applications/Server.app/Contents/ServerRoot/usr/bin/pg_dump -h localhost -U caldav caldav -f. Sudo -u _calendar /Applications/Server.app/Contents/ServerRoot/usr/bin/postgres_real -D /Library/Server/Calendar\ and\ Contacts/Data/Database.xpg/cluster.pg
Sudo rm /Library/Server/Calendar\ and\ Contacts/Data/Database.xpg/cluster.pg/postmaster.pid Some combination of the commands pg_dump, psql, and Python's psycopg2 library are helpful. The idea here is to figure out the PostgreSQL calendar_object.calendar_resource_id for the desired user, then save all the corresponding. Server.app>Calendar> Turn off, if this even works.This is a complete hack to access the database tables and calendar. PostgreSQL dump of the Calendar and Contacts database Sudo /Applications/Server.app/Contents/ServerRoot/usr/sbin/calendarserver_export -debug -u username -contacts -d ~/Downloads/Calendar\ and\ Contacts\ Backup/username Sudo /Applications/Server.app/Contents/ServerRoot/usr/sbin/calendarserver_export -debug -u username -calendars -d ~/Downloads/Calendar\ and\ Contacts\ Backup/username mkdir -p ~/Downloads/Calendar\ and\ Contacts\ Backup/username
#DOWNLOAD MACOS SERVER UPGRADE#
The command calendarserver_export didn't work for me because the Calendar and Contacts database was broken after an upgrade of macOS Server. Backup all data in as many ways as possible Time Machine and bootable Carbon Copy Clone of server Server: Export per-user calendar and contacts itemsĪlso see the PostgreSQL query and dump cpmmands below. This is what I had to do to fix everything. My Calendars and Contacts broke after a macOS Server upgrade. MacOS Server Fix and Restore Broken Calendars and Contacts
0 kommentar(er)
