PostgreSQL database system for all types of databases (configuration, log, archive) is fully supported in D2000 System from version V10.0.38. In lower the previous version V10.0.37, user may use PostgreSQL only in connection with can be used only for archive databases.
PostgreSQL installation
...
To use the PostgreSQL, it must be installed on the target computer. Installation can be done in two ways either manually or through the D2000 System installer, which fully installs all of the necessary components of PostgreSQL.
Note: we recommend installing PostgreSQL manually. For the selected version of PostgreSQL (e.g. 12), download and install the latest patch (e.g. 12.10). Then download the latest ODBC driver patch for the selected version (e.g. for version 12 it is at the time of writing this documentation psqlodbc_12_02_0000.zip). Caution - using a lower version PostgreSQL ODBC driver (e.g. 11) with a newer version of a PostgreSQL database (e.g. 12) can cause various problems and malfunctions!
| Kotva | ||||
|---|---|---|---|---|
|
Installation by the D2000 System installer is more user-friendly. It ensures installing of all necessary components for fully full integration with D2000 System. This method is mainly recommended for users who do not have not any experience with the PostgreSQL.
To install PostgreSQL, the user must check the Install the PostgreSQL in D2000 System Configuration Guide in this dialog window:
In some situations, this checkbox could be disabled, which means that the installer detected PostgreSQL on the computer and any no other installation is not necessary. The installer does not allow to install other PostgreSQLthe installation of another PostgreSQL instance.
If PostgreSQL installation is enabled, the installer of PostgreSQL is started along with the configurator of the D2000 System. It requires to set setting some important parameters concerning the PostgreSQL and configure configuring appropriate database service (see the section PostgreSQL structure). PostgreSQL installer guides the user through the dialog windows which enables to set some necessary parameters. Most of the windows contains contain the default value which is recommended for standard purposes.
...
- Process of installation starts with the welcome dialog window:
- In second step, user must select or enter a location on disc where the installation will be done:
Then select the location where data files for PostgreSQL service will be stored:Kotva step3 step3 
This directory will contain the configuration and auxiliary files for PostgreSQL service (see more information in section PostgreSQL structure). The directory does not contain database files from D2000 System databases.
It is shared by all databases on target computer, therefore it should not be placed in such a directory, which can be deleted (for example directory structure of D2000 System).- Enter the password for main user. Each PostgreSQL service contains the main user with name postgres who has an administrator rights (creating new databases, users, ...). This password is very important because it will be required every time when user will create application or archive on PostgreSQL.
Then enter the port number the service will listen on.Kotva step5 step5 
Mostly, default port is convenient. If the process that listens on given port already exists on the target computer, you should change port number to avoid the conflict between processes.- Select the location.
Default value [Default locale] is the location that is set according to operating system. - In the next dialog windows, confirm the settings that are necessary for installation.
- After finishing the installation of D2000 instance, all necessary components of PostgreSQL are installed for cooperation of these two systems.
...
After installation, the target computer contains the files of PostgreSQL in selected directory. For example, the utility psql.exe is placed in subdirectory bin. It allows to work with database on command line.
When installing, default PostgreSQL service with name postgresql-XXX-VV is created (where XXX defines the architecture x86/x64 and VV defines the version of database system, e.g. 9.3). This service is the main part of PostgreSQL. You may work (create databases, connect to database,...) with the database system unless this service is running.
...
The most important configuration files of database service are:
- postgresql.conf
It is the basic configuration file, in which you may change the configuration of service, such as the configuration of network interfaces which database listen on, cache size,... - pg_hba.conf
It is configuration file that specifies the users who can connect to database system and which way. This configuration file is necessary change only in case of connection to database system from external network. More information is mention in the section Connection to PostgreSQL database running on dedicated machine.
...
- starting the command:
pg_ctl reload
from the command line (utility pg_ctl.exe is placed in the subdirectory bin in PostgreSQL installation directory) - starting the SQL query:
SELECT pg_reload_conf();
...
To manage PostgreSQL databases, user may use either utility psql.exe (it is placed in bin subdirectory of installation directory), which enables to browse and manage the system by command line, or graphic tool pgAdmin III, which is installed together with the database system.
...