QHB Installation Guide for 1C
The first step is to install QHB. After that, you need to initialize the database cluster with the required parameters:
sudo -u qhb /usr/local/qhb/bin/qhb_bootstrap --locale=ru_RU.UTF-8 --lc-collate=ru_RU.UTF-8 --lc-ctype=ru_RU.UTF-8 --encoding=UTF8 -D /u01/1CBase/ -U qhb
Then you need to create a database, and then connect it to 1C. This can be done in two ways: via the 1C server administration console or via the 1C application. In both cases, you need to specify information in the fields for adding an infobase in accordance with your configuration and infrastructure. In the "DBMS Type" field, you need to select PostgreSQL.
As an example of specifying the parameters of the infobase, we can analyze adding an information base through the 1C application.
| Column Name | Required Data |
|---|---|
| 1C:Enterprise Server Cluster | Server cluster name |
| The name of the infobase in the cluster | Name of the created base |
| Secure connection | The option you choose depends on your configuration; default is "Disabled" |
| DBMS type | PostgreSQL |
| Database server | IPv6 address |
| Database name | Database name |
| Database user | User name with permissions to create a database on the database server |
| User password | Password of the user with permissions to create a database on the database server |
| Date offset | The parameter choice depends on your configuration; default is 0 |
Specifying the Create database if it does not exist flag will create a new database without the need to create a database instance preliminary.
WARNING!
For correct operation, you must execute the following command on each database instance:UPDATE pg_catalog.pg_operator SET oprcanhash = false WHERE oid in (7200, 7201);