B3. Using the PostgreSQL DBMS |
General Description PostgreSQL is an object-relational DBMS distributed as a freeware unlike such commercial DBMS as Oracle Database, Microsoft SQL Server, etc. The PostgreSQL DBMS may be used to arrange an external DB for Dr.Web Enterprise Security Suite in large anti-virus networks. To use PostgreSQL as an external database 1.Install the PostgreSQL server. 2.Set up Dr.Web Server to use the respective external database. You can do this in configuration file or via Dr.Web Security Control Center: in the menu, the tab.
Installation and Supported Versions 1.Download the latest available version of this free product (the server and correspondent ODBC-driver), otherwise do not use the version earlier than . 2.Create the PostgreSQL database by one of the following ways: a)Using the pgAdmin graphical interface. b)Using the CREATE DATABASE SQL command.
For more information about conversion to the external database see p. Changing the Type of the DBMS for Dr.Web Enterprise Security Suite. Also, please note the system requirements for Dr.Web Server when operating with the PostgreSQL external database (see , p. System Requirements). Parameters When setting access to PostgreSQL, use parameters described in the table below. PostgreSQL parameters
More information can be found at http://www.postgresql.org/docs/manuals/. Dr.Web Server and PosrtgreSQL DB Interaction via the UDS If Dr.Web Server and the PostgreSQL DB are installed on the same computer, their interaction can be set via the UDS (UNIX domain socket). To set interaction via the UDS 1.In the postgresql.conf PostgreSQL configuration file, specify the following directory for the UDS: unix_socket_directory = '/var/run/postgresql' 2.Restart the PostgreSQL. Configuring the PostgreSQL Database To increase performance during interaction with the PostgreSQL database, it is recommended to configure it according to the information from the official documentation on the database. If you use a large database and dispose the appropriate computing resources, it is recommended to configure the following parameters in the postgresql.conf configuration file: Minimal configuration:
Extended configuration:
|