CONFIGURE POSTGRESQL INSTALL
CONFIGURE POSTGRESQL MANUAL

By default, RStudio uses SQLite, installing the necessary dependencies and automatically creating the database. RStudio Workbench 1.4 (and above) uses a database for internal purposes. This article provides a primer for getting started but is not intended to be a comprehensive explanation of best practices for configuring and operating Postgres in a production environment. Note: The official name is 'PostgreSQL' but often shortened to 'Postgres'. Kaspersky Scan Engine does not use any other databases.System Administrators who are unfamiliar with basic installation and configuration of the PostgreSQL database engine for RStudio Workbench (previously RStudio Server Pro).

CONFIGURE POSTGRESQL MANUAL

You can use the postgres user for that, or create a new user.Īfter installing PostgreSQL and setting the password for the postgres user, you can proceed to section Installation using script (Linux) or Manual installation (Linux).Īll data is stored in a single database called kavebase.

CONFIGURE POSTGRESQL INSTALL

To install Kaspersky Scan Engine GUI, you need a PostgreSQL user that has permissions for creating new databases and users. You can now install Kaspersky Scan Engine GUI. Quit the psql utility by running the following command in psql:.Here %PASSWORD% is the new password for the postgres user. In psql, change the password of the postgres user by running the following command:Īlter user postgres with password '%PASSWORD%'.Under the postgres user account, start the psql utility by running the following command in the command line:.From the command line, change the currect user to the postgres user:.To set the password for the postgres user: By default, this user does not a have a password. Set the password for the default PostgreSQL user.ĭuring installation PostgreSQL creates a superuser called postgres.Restart PostgreSQL by running the following command from the command line:.

Here %IP% is the IP address of the computer on which Kaspersky Scan Engine is installed.

If PostgreSQL and Kaspersky Scan Engine are installed on different computers, add the following line to pg_hba.conf:.

Find the following line in pg_hba.conf:.

Specify that PostgreSQL must require an MD5-encrypted password for authentication from all of its clients:.

This file is located in the same directory as nf.

Open the pg_hba.conf configuration file.

Specify the port on which the PostgreSQL is to listen for connections from Kaspersky Scan Engine in the port setting of nf.

Specify the IP address that Kaspersky Scan Engine must use to connect to PostgreSQL in the listen_addresses setting of nf.

If you use another operating system, the location of nf may be different.

In RedHat-based Linux distributions nf is located at /var/lib/pgsql/data/.

In Debian-based Linux distributions nf is located at /etc/postgresql/10/main/.

The location of this file varies depending on your operating system: Visit to see a list of supported operating systems and installation instructions for each of them.

Install the package downloaded from the PostgreSQL website.

You can install PostgreSQL in one of the following ways: The procedure for a later version may vary. The following procedure covers installation and configuration of PostgreSQL 10.7. Kaspersky Scan Engine GUI requires PostgreSQL 10.7 or later. Installing and configuring PostgreSQL (Linux)

Configure postgresql