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 the Dr.Web Enterprise Server in large anti-virus networks.
To do this:
1.Install the PostgreSQL server.
2.Set up the ODBC driver.
3.Set up the Dr.Web Enterprise Server to use the respective external database. You can do this in configuration file or via the Dr.Web Control Center: Configure Dr.Web Enterprise Server, Database tab.
Installation and Supported Versions
Please 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.2.
|
PostgreSQL DMBS is compatible with the following platforms: Linux, Solaris/OpenSolaris, Win32, MacOS X, FreeBSD. |
For more information about conversion to the external database see p. Changing the Type of the DBMS for Dr.Web Enterprise Security Suite.
For more information about installation of Enterprise Server using external database see step 10 in p. Installing the Dr.Web Enterprise Server for Windows® OS.
|
Please mind that the ANSI version of the ODBC driver can be used starting from PostgreSQL 8.2.4 version only. The Unicode ODBC driver will work fine in all versions. |
Installation for 64-bit systems
PsqlODBC driver for x64 systems is not supplied by an official developer. However, according to the PostgreSQL DBMS official web-site, prerelease installation packages can be installed. You can download these packages, for instance, using following links:
◆http://www.enterprisedb.com/products/pgdownload.do#windows
◆http://code.google.com/p/visionmap/wiki/psqlODBC
◆http://www.geocities.jp/inocchichichi/psqlodbc/index.html
|
After installation of the ODBC-driver on 64-bit OS, to get access to drivers, use administrative management panel, resides in: С:\WINDOWS\SYSWOW64\odbcad32.exe. |
Parameters
When setting access to PostgreSQL, use the parameters described below.
PostgreSQL parameters (only in the version for UNIX OS)
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 |
More information can be found at http://www.postgresql.org/docs/manuals/.
Dr.Web Enterprise Server and PosrtgreSQL DB Interaction via the UDS
If the Enterprise 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.