Skip to main content

Posts

Showing posts with the label Automatic DB backup

Schedule Backup using DBExport from Adempiere ERP in Windows OS

Scheduled Backup from Postgres using pgagent is possible , but the size of Backup file generated is very large compared to that generated from Adempiere using DbExport.bat. Creating Backup from adempiere by scheduling running of RUN_DBExport.bat from adempiere periodicaly using windows task scheduler is a viable solution. There are few bat files that need to be changed * E:\Adempiere\utils\myDBcopy.bat * E:\Adempiere\utils\RUN_DBExport.bat * E:\Adempiere\utils\postgresql\DBExport.bat In the above case  "E:\Adempiere\" is the path of Adempiere home where it was build. Make necessary changes as needed. NB: The environment variables are to be set properly in "Computer>properties>Advanced System Settings>Advanced>Environment variables "so as to make the following steps work. First file  to be changed is E:\Adempiere\utils\myDBcopy.bat Here change "set DATETIME=%date:~6,4%%date:~3,2%%date:~0,2%_%TIME:~0,2%%TIME:~3,2%%TIME:~6,2%"