How do I move or backup MacOS X 10.7 Lion Server wikis?

Why I know that you will write that you have no backup ;-)

If you can´t boot from the old system then you can´t dump the last version of the database - and no, I will not show you how to modiy configurationfiles for that ... because this brings many security holes.

As long as you can mount / activate the old partition - you can also copy the daily dump from all databases which the system runs self. You lost maybe 24 hour but it is better then nothing - it also helps people to remind to make a backup.

The dumpall.psql.gz and dumpall.psql you will find in /Library/Server/PostgreSQL/Backup on the old partition. And don´t forget to copy the data folder of the wiki - see posts before.

thank you for help

If I had a backup, I would not post )

/Library/Server/PostgreSQL/Backup on the old partition is empty, i checked it out first (

seems i have only raw database's files in /var/pgsql

If the directory is empty it could also be that you don´t have any DB anymore ... who knows.

The following things are only ideas and highly experimental.

1.) Stop all services as described.

2.) Unloud the LaunchDaemon to be sure PostgreSQL is reall down using

sudo launchctl unload /System/Library/LaunchDaemons/org.postgresql.postgres.plist

3.) Backup the new pgsql directory using

sudo -u _postgres mv /var/pgsql /var/pgsql.old

4.) Move the old pgsql directory (the default name of your Lion partition is normally Macintosh HD - if not change it as needed) from the old volume to the new volume using

sudo -u _postgres cp -R "/Volumes/Macintosh HD/var/pgsql" /var/pgsq

5.) Restore the Wiki folder.

6.) Reboot and hope that it works.

The paths are typed on the fly - so check it before you use it. There was a binary update of PostgreSQL from 10.7.2 to 10.7.3 from version 9.0.4 to 9.0.5 - the DB cluster itself must normally not be migrated but it could be that something has changed in the config files. So if you get it to work, make single dumps of the DB´s, set up a clean install again and restore the DB´s.

AND START TO MAKE BACKUPS - IT MAKES YOUR LIFE AND THE LIFE OF OTHERS MORE EASY !

Christoph thank you very much!

finally i did it works

my sequence:

1) stop wiki in server.app

2) remove /var/pgsql

3) move old folder in /var

4) chown -R _postgres:_postgres folder

5) sudo launchctl unload /System/Library/LaunchDaemons/org.postgresql.postgres.plist

6) start wiki service

Good to hear.

As information for all who has the same problem. It is really important to stop all running services, because launchd (.plist) restarts all servies if anotherone needs it.

And run sudo launchctl unload /System/Library/LaunchDaemons/org.postgresql.postgres.plist BEFORE you do anything in / with the pgsql folder. Otherwise it could be that you self corrupt your database - if the .plist was unloaded normally all open files / connections to them are closed.

@leskovartem : treat your new friend - TimeMachine - good.

Thanks all - this fixed a broken wiki and profile manager:

1) Stop services in terminal (as above)

2) $ sudo touch /Library/Logs/PostgreSQL.log

3) $ sudo chown _postgres:admin /Library/Logs/PostgreSQL.log

4) Restart services in terminal (as above)

5) Reboot

Is it possible to migrate my wiki away from OS X Lion and into Confluence?