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 Dr.Web Server configuration menu, the Database tab.

If you are going to use the PostgreSQL DB as an external database via the ODBC connection, then during installation (upgrading) of the Server, in the installer settings, disable the installation of embedded client for PostgreSQL DBMS (in the Database support → PostgreSQL database driver section).

Otherwise, interaction with the PostgreSQL DB via ODBC will fail because of the libraries conflict.

To connect to the PostgreSQL DB you can use only trust authorization, password and MD5 (Kerberos, GSS and SSPI are not supported).

Installation and Supported Versions

1.Download the latest available version of this free product (the PostgreSQL server and correspondent ODBC-driver), otherwise do not use the version earlier than 8.4.

2.Create the PostgreSQL database by one of the following ways:

a)Using the pgAdmin graphical interface.

b)Using the CREATE DATABASE SQL command.

Database must be created in the UTF8 encoding.

For more information about conversion to the external database see p. Changing the Type of the DBMS for Dr.Web Enterprise Security Suite.

Parameters

When setting access to PostgreSQL, use parameters described in the table below.

PostgreSQL parameters

Name	Default value	Description
host	<UNIX domain socket>	PostgreSQL server host
port		PostgreSQL server port or name extension of the socket file
dbname	drwcs	Database name
user	drwcs	User name
password	drwcs	Password
options		Debug/trace options for sending to the Server
tty		File or tty to output at debug
requiressl		1 instructs to request a SSL connection; 0 does not instruct to make the request
temp_tablespaces		Name space for temporary tables
default_transaction_isolation		Transaction isolation mode (see PostgreSQL documentation)

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.