In case you need to upgrade, update or maintain your Acronis Access server. This article will give you the basics of backing up your database and restoring it.
Note: If your Acronis Access server database is very large, several gigabytes, you may want to use a different backup and restore method for your database. Please contact our technical support at http://www.acronis.com/en-us/mobilitysupport/ for help and instructions.
Backing up Acronis Access
Backup the Access Server's database
Stop the Acronis Access Tomcat service
Open the Acronis Access PostgreSQL Administrator application and connect to the database server. You may be prompted to enter the password for your postgres user.
Expand Databases and right-click on the acronisaccess_production database.
Choose Maintenance -> Vacuum and press OK.
Expand the database, expand Schemas and expand Public. Take note of the number of the Tables section. This will help you verify that the database transfer is successful.
Close the PostgreSQL Administrator and open an elevated command prompt.
In the command prompt, navigate to the PostgreSQL bin directory.
Enter the following command: pg_dumpall --host localhost --port 5432 --username postgres --inserts --file alldbs_inserts.sql
alldbs_inserts.sql will be the filename of the backup. It will be saved in the PostgreSQL bin directory. You can use a path in the above command if you wish to save it somewhere else - e.g. change the last part of the command above like so: --file D:\Backups\alldbs_inserts.sql
If you are using a non-default port, change 5432 to the correct port number.
If you are not using the default PSQL administrative account postgres, please change postgres to the name of your administrative account in the command above.
Copy the backup file to a safe location.
Backup the Gateway Server's database
Stop the Acronis Access Gateway service.
Go to the Gateway Server database folder, by default located at:
Copy the mobilEcho.sqlite3 file to a safe location.
Additional files to backup
If you've made changes to any of these files, it is recommended to make backups so you can transfer your settings when restoring or migrating your Acronis Access product.
web.xml located by default at C:\Program Files (x86)\Acronis\Access\Access Server\Web Application\WEB-INF\. Contains Single Sign-On settings.
server.xml located by default at C:\Program Files (x86)\Acronis\Access\Access Server. Contains Tomcat settings.
krb5.conf located by default at C:\Program Files (x86)\Acronis\Access\Common\apache-tomcat-7.0.59\conf. Contains Single Sign-On settings.
Your certificates and keys used for Acronis Access.
Custom color schemes located by default at C:\Program Files (x86)\Acronis\Access\Access Server\Web Application\customizations\.
pg_hba.conf located by default at C:\Program Files\PostgreSQL\9.2\data\.
newrelic.yml file if you are using New Relic to monitor your Acronis Access server.
Restoring Acronis Access
Restore the Access Server database
Note: We strongly recommend that you run a test backup/restoration outside of your production environment.
Open the Services control panel and stop the Acronis Access Tomcat service.
Open the Acronis Access PostgreSQL Administrator application, connect to the local database server, select Databases, and confirm there is a database called acronisaccess_production.
Right-click on the database and select Refresh.
Expand it and expand Schemas, expand Public and verify that there are zero (0) Tables.
If there are any tables in the database, right click on the database and rename it to oldacronisaccess_production. Finally, go to Databases, right-click and create a new database called acronisaccess_production.
Close the PostgreSQL Administrator and open an elevated command prompt.
In the command prompt, navigate to the PostgreSQL bin directory.
Copy the database backup file alldbs_inserts.sql (or whatever you have named it) into the bin directory.
In the command prompt, enter the following command: psql -U postgres -f alldbs_inserts.sql
Enter your postgres password when prompted for it.
Note: Depending on the size of your database, the restore can take some time.
After the restore is complete, close the command prompt window.
Start the Acronis Access Tomcat service.
Restore the Gateway Server database
Copy the mobliEcho.sqlite3 Gateway Server database backup into the new Gateway Server's database folder (by default C:\Program Files (x86)\Acronis\Access\Gateway Server\database) replacing the existing file.