Installing and configuring PostgreSQL (Windows)

To install and configure PostgreSQL:

  1. 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.

  2. 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.
  3. Specify the IP address that Kaspersky Scan Engine must use to connect to PostgreSQL in the listen_addresses setting of postgresql.conf.
  4. Specify the port on which the PostgreSQL is to listen for connections from Kaspersky Scan Engine in the port setting of postgresql.conf.
  5. Save and close postgresql.conf.
  6. Open the pg_hba.conf configuration file. This file is located in the same folder as postgresql.conf.
  7. 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 to md5.

  8. 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.

  9. Save and close pg_hba.conf.
  10. 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.

Page top