cancel
Showing results for 
Search instead for 
Did you mean: 

Backup & Restore

aj_eosensa
Champ in-the-making
Champ in-the-making
i have searched all docs's and sources in an attempt to figure out how to properly and securely backup the  alfresco db

ok this is what i understand, i need to backup the alfresco folder (including alf_data) in conjunction to an sql db backup. ok cool this is where i hit a brick wall


i see that it comes with a folder postgresql and in the bin folder there are two files pg_dump and pg_dumpall

should i be using these two folders to backup the database, where is the backup output put? ive attempted to run ./pg_dumpall and it wont allow me to put in a password. but when i run default scripts with the pw it works, where are the default locations for the backup

i am at about hour 4 of troubleshooting this, this is the last step before our alfresco server goes into production and i could really use the communities help

i have read all the documents hot and cold backups and restores as per the wiki and whatnot, if someone in plain english could post how they go about backing up the server it would be GREATLY appreciated as i am mentally spent at this point

please note this is running on OSX but if you show directories it will be along the same lines

thanks in advance!
AJ
4 REPLIES 4

aj_eosensa
Champ in-the-making
Champ in-the-making
bump!

still stuck on this issue! anyones input would be greatly appreciated

aj_eosensa
Champ in-the-making
Champ in-the-making
any help would be greatly appreciated

bisana
Champ on-the-rise
Champ on-the-rise
Hi
I use MySQL(will be using postgresql) in future instance.
I created a script to backup the DM to another machine using rsync which runs daily at midnight, the steps are
(1) stop the alfresco
(2) dump the database
(3) rsync the DB files to the backup server
(4) rsync the alfresco install directory to the backup server
(5) start the alfresco
Please try this procedure

isra_vass
Champ on-the-rise
Champ on-the-rise
Have you check this thread?

https://forums.alfresco.com/forum/installation-upgrades-configuration-integration/configuration/how-...

Tha backup method using postgreSQL is with the pg_dump or pg_dumpall files. In that thread you can find the commands to do so.

Iunno if that was your question…

Hope it helps,

Regards