Data that needs to be migrated:
individual companies
license file
user passwords
Two approaches for migrating everything:
by transferring the complete data storage
by restoring from a backup
Transferring the Complete Data Storage
This approach is the fastest, but can only be used if you are moving to another server running the same operating system with the same architecture (note: moving from 32-bit to 64-bit is already a different architecture) and the same version of PostgreSQL.
Install the Flexi system on the new server, then stop it (Starting a stopped server); on Linux you also need to stop the PostgreSQL database engine (e.g. as /etc/init.d/postgresql-8.4 stop),
move the database storage (usually c:\winstrom-data\ or /var/lib/flexi, more details at Directory Locations,
you now need to set the permissions correctly — on Linux, do this manually according to the original data source directory (the one you overwrote); on MS Windows, we recommend a fresh installation which will correct the access rights settings,
start the Flexi service and the database server will start simultaneously.
Manual Restore from Backup
This approach is the most reliable, but also the most labor-intensive. It can be used either for emergency recovery or when moving to a different operating system (e.g. from MS Windows to Linux).
install the Flexi system and connect to it,
upload the license file,
restore individual companies from backup via the application; users will be created automatically and their access rights to the companies will be configured,
set user passwords again — these are not included in the backup.
If you also restore the centralServer database from backup (this must be done manually, as it cannot be done through the application), passwords and the license will be preserved.
Alternatively, you can also use the pg_dumpall tool for the migration. If you use pg_dumpall, please read Migrating from PostgreSQL 8.x to 9.x using pg_dumpall.
License File
The license file authorizes the operation of the Flexi system on a single server. The system includes automatic license activation. Therefore, if you are moving everything to a different server, no special step is required (other than transferring the license file).
Note:
Please make sure that the original installation is no longer started afterwards, as doing so could cause issues with automatic activation.
Upgrading to a New Version of PostgreSQL
In general, the manual restore from backup procedure can be used. For Debian/Ubuntu, a simple tool is available: pg_upgradecluster 8.4 flexibee
After upgrading the cluster, a reindex of indexes must be performed.
Documentation can be found here.