XQA installation - Xopero: cant run postgres

The "cant run postgres" error occurs most often when the database update installation process fails, after the firmware update from QTS 4.2 to QTS 4.3. Follow the steps below to start the database.

The package of Xopero QNAP Appliance for QTS 4.3 must be x86_64.

1. Connect with QNAP server by SSH. This is possible e.g. by free software PuTTy. In field Host Name (or IP address) enter the QNAP address, choose connection type, SSH. Then press the Open button or, if necessary, change other settings,

2. After logging into QNAP server, go to /share/CACHEDEV1_DATA/.qpkg/Xopero by command cd /share/CACHEDEV1_DATA/.qpkg/Xopero,

3. Execute the command: cp postgresql.conf.org9.5 postgresql.conf.org,

4. Execute the Xopero server restart command: /etc/init.d/XoperoServer.sh restart,

5. After the restart, check the system Xopero working. If you are still having trouble logging into Xopero, follow these steps,

6. Start the server database with a command: /etc/init.d/XoperoServer.sh psql start,

7. Press: [CTRL] + [Z],

8. Enter the command: /etc/init.d/XoperoServer.sh psql opero21,

9. Enter: CREATE ROLE webrequestsuser LOGIN SUPERUSER INHERIT CREATEDB CREATEROLE REPLICATION; and click [ENTER],

10. Enter: ALTER ROLE webrequestsuser SET statement_timeout = '180000'; and press [ENTER] again,

11. Press: [CTRL] + [Z],

12. Restart the Xopero server: /etc/init.d/XoperoServer.sh restart,

13. Check the Xopero working.