Sorry, thicko question:
I have 4.0b installed (Debian package) and am using the bundled Postgres server. I want to script a basic backup procedure which I think would be something along the lines of (according to the wiki):
1. backup the postgres db
2. tar up and back up whole of alf_data to some backup location
I'd imagine the backed up db and the alf_data need to be 'syncronised' (excuse if this is the wrong term) in that it would be advisable to stop alfresco before doing these two steps.
The problem then comes in that, of course, by stopping alfresco using alfresco.sh, postgres is also shut down. As such, using pg_dump doesn't work because it cannot connect to the server.
I suppose I could backup the postgres db before shutting down alfresco, then copy out alf_data, but I can see an unlikely but possible scenario whereby a used, say, adds a document after the postgres backup starts but before the server is shut down to do the alf_data backup. I presume then a restore of the two out-of-sync elements might prove problematic.
Am I over-complicating this for myself?
Thanks for any guidance anyone might be able to give.