Awhile back I wrote a quick launchd script to backup the Profile Manager PostgreSQL database in Lion Server.

The project is available here – https://github.com/hansen-m/pmbackup