How to backup & restore an Apple Profile Manager database

[Carter]

Today I needed to look at rebuilding or at least testing out a new Profile Manager Server setup but wanted to move all the clients and groups from the old PM server to the new test server but Apple has nothing in place to just export and import this. I found a topic on the Apple Discussions that has quick terminal commands to backup and restore PM Server. As a quick test I did this with our MacMini PM Server and moved restored it on a MacBook Pro running the latest version of PM Server. (OS X Server 1.5.0 --> OS X Server 2.1.1)

 

To backup the DB in Terminal :

 

sudo pg_dump -U _postgres -c device_management > $HOME/device_management.sql

 

To restore the DB in Terminal :

 

sudo serveradmin stop devicemgr

sudo serveradmin start postgres

sudo psql -U _postgres -d device_management -f $HOME/device_management.sql

sudo serveradmin start devicemgr

 

Found the article here https://discussions.apple.com/message/17804347#17804347 with the credit going to "Christoph Murauer" ​for the info

Edited November 20, 2012 by Carter