Q: Manually Backup MacOS X 10.7 Lion Server PostgreSQL DB
Hello,
I am sure most of you are aware that Time Machine does NOT properly backup your Wiki's and your users Calendars and Contact information. I am even more appalled that this is still even an issue in 10.7.5. I wonder if management over at Apple is aware that it's Tech Support Employees are telling customers to NOT trust Time Machine backups and use a 3rd party backup for your server when states on Apple's website and I quote "OS X Server also takes advantage of Time Machine to back up your server data — including shared files, calendars, mail, wikis, and more — to another hard drive, so you can easily restore to an earlier configuration". Somthing needs to be done about this!
From what I can tell the problem is this (Can anyone confirm?):
1. Time Machine fails to update and or create dumpall.psql.gz in the Library/Server/PostgreSQL/Backup/ directory
2. Time Machine is denied access to the dumpall.psql file during the restore process and restores the dumpall.psql.gz file.
This end result is either a blank database or database from last date Time Machine was able to create or modify the dumpall.psql.gz file.
How can you manually backup and restore your PostgreSQL database so you do not loose your Wiki's, Wiki files or users contacts and calendars?
Thanks,
ebrind
Posted on Mar 7, 2013 7:43 AM









