Installing and configuring PostgreSQL (Windows)
To install and configure PostgreSQL:
- Download and install PostgreSQL.
Visit https://www.enterprisedb.com/downloads/postgres-postgresql-downloads to see a list of supported operating systems and download the installer.
- Open the
postgresql.conf
configuration file. This file is located at%postgresql_dir%\data
. Here%postgresql_dir%
(for example,C:\Program Files\PostgreSQL\11
) is the folder that PostgreSQL was installed in. - Specify the IP address that Kaspersky Scan Engine must use to connect to PostgreSQL in the
listen_addresses
setting ofpostgresql.conf
. - Specify the port on which the PostgreSQL is to listen for connections from Kaspersky Scan Engine in the
port
setting ofpostgresql.conf
. - Save and close
postgresql.conf
. - Open the
pg_hba.conf
configuration file. This file is located in the same folder aspostgresql.conf
. - Make sure that PostgreSQL requires an MD5-encrypted password for authentication from all of its clients. Find the following line in
pg_hba.conf
:host all all 127.0.0.1/32 md5
If the authentication method specified on this line is other than
md5
, change it tomd5
. - If PostgreSQL and Kaspersky Scan Engine are installed on different computers, add the following line to
pg_hba.conf
:host all all %IP%/32 md5
Here
%IP%
is the IP address of the computer on which Kaspersky Scan Engine is installed. - Save and close
pg_hba.conf
. - Restart PostgreSQL by running the following command from the command line:
sc stop postgresql-x64-11
sc start postgresql-x64-11
You can now install Kaspersky Scan Engine GUI.
To install Kaspersky Scan Engine GUI, you need a PostgreSQL user that has permissions for creating new databases and users. You can use the postgres user for that, or create a new user.
After installing PostgreSQL, you can proceed to section Installation using installer (Windows) or Manual installation (Windows).
All data is stored in a single database called kavebase. Kaspersky Scan Engine does not use any other databases.