As of version 2022.5, new installations and updates of ABRA Flexi on Windows and macOS require PostgreSQL 13. When updating a server installation on Windows and macOS, the data files will be automatically migrated to the new version of PostgreSQL.
Automatic update on Linux is not currently supported, so the new version will not be deployed to RPM/DEB repositories for the time being. Do not manually install the 2022.5.x package — it will not work with PostgreSQL 9.x.
0. Recommendations and system requirements for the database update
Please make sure you allocate sufficient time for the update.
As a precaution, we recommend backing up your accounting data in advance.
The migration will require sufficient free disk space and may be very time-consuming.
Windows OS is now only supported in the 64-bit variant with NTFS (data cannot be stored on FAT32).
The minimum required version of macOS is now 10.14 Mojave.
On Linux, support for older PostgreSQL versions 8.3 through 9.6 has been discontinued. Version 10 is the minimum (version 13 remains the maximum).
Discontinuation of support for database procedures written in PL/Tcl. Any custom procedures in this language must be removed from the databases.
If these requirements are not met, we cannot guarantee a successful update.
The following sections describe the installation and update process for ABRA Flexi, including the PostgreSQL upgrade.
1. Downloading the ABRA Flexi installation package
The version for self-hosted servers and local installations is available in the downloads section.
In the downloads section, you will find and download the universal package for your operating system. The universal package is required for both local installations and server installations. The package also includes the database system installation.
2. Installation (update)
Before starting the installation, fully close the ABRA Flexi application if it is running. Additionally, any active API integrations (connections to other systems) or webhooks that automatically write data in the background must be disabled.
You can now launch the installation package. On macOS, the system may reject the installation package with the following message:
Instructions on how to resolve this issue can be found in the documentation — Installing ABRA Flexi on macOS.
After completing the initial installation steps,
and after accepting the license agreement, the installer will prompt you to update the PostgreSQL database system:
The installation requires a PostgreSQL installation package. The installer will download this package automatically if the computer is connected to the internet. You can also download it manually from the following address:
macOS
Windows
for migration from PostgreSQL 8
for migration from PostgreSQL 9 https://download.flexibee.eu/download/pgsql/windows/postgresql-9.3.zip
The next screen warns that the installation process may take a considerable amount of time, during which access to data will not be possible. Confirm by clicking "Next".
On the next installer screen, you have the option to specify the path to a manually downloaded PostgreSQL installation package. The package is in ZIP archive format — do not modify or extract the archive; simply select the path to it and confirm by clicking "Next".
In the next step, the archive will be extracted and the installer for the database system update will be prepared.
The last step before the actual database system update is a confirmation screen where you approve the PostgreSQL upgrade and the data migration begins. The old data can be archived at the end of the update process, so there is no risk of data loss. Confirm by clicking "Next".
A status screen displays the progress of the update in a simple format. No user interaction is required; the process may take several tens of minutes.
Once the update has completed successfully, the user is notified and the installer can be "Closed".
The old data from the previous version of ABRA Flexi can be retained; the user is prompted to save the data to the Data_old folder.
If the database update was not successful, a message will be displayed informing the user of the failure and prompting them to delete the data directory of the new version. The original data from before the update will remain intact.
If the database system update was unsuccessful, please contact our technical support team at podporaflexi@abra.eu. To help us resolve the issue more quickly, please attach the installation log straight away — see question 1 in the FAQ below.
FAQ
Where can I find the update log to identify errors?
Windows — logs are located in the directory flexi-upgrade, which can be found in the directory C:\Users\{jméno uživatele}\AppData\Local\Temp\
macOS — the log can be found in the directory /Library/Application\ Support/FlexiBee/flexi-upgrade/
During the database update, error C:\Users\{uzivatel}\AppData\Local\Temp\flexi-upgrade\pgsql\share\tsearch_data\danish.stop appears
See screenshot.
We have observed this error on Windows Server 2019. The issue is caused by FSRM (File Server Resource Manager). The solution is to set it to passive mode.
Where can I find the application and database directories?
Can I roll back to a previous version of ABRA Flexi?
Unfortunately not. After the update, you must use ABRA Flexi 2022.5.0 or later, along with the associated PostgreSQL 13 database system.
Can users work during the update?
No. Before starting the installation, fully close the ABRA Flexi application if it is running. Additionally, any active API integrations (connections to other systems) or webhooks that automatically write data in the background must be disabled.
What are the requirements for a local installation or server?
Do I need to perform the update if I have a cloud licence?
If you are using a subscription licence with your data hosted in our cloud, this update is not required for you.
How can I get information about the database system's operation?
The PostgreSQL database server automatically writes information about its operation to the system log.
Need help?
If you have any questions about the application, please contact us at podporaflexi@abra.eu or via the chat window in the bottom right corner.