lkpvegan.blogg.se - Best windows gui for postgres

You can use the postgres user for that, or create a new user.Īfter installing PostgreSQL, you can proceed to section " Installation using installer (Windows)" or " Manual installation (Windows)".Īll data is stored in a single database called kavebase. 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. If you use the psql utility, specify a space character and a user name after the -U parameter, as follows: psql -U postgresĪLTER ROLE username WITH PASSWORD 'your password' You can use either the psql utility or pgAdmin to perform this action.

If step 5 was performed, you have to update the password for the superuser on the computer that has PostgreSQL installed.

Restart PostgreSQL by running the following commands 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:.

If the authentication method specified on this line is other than md5, change it to md5.

Make sure that PostgreSQL requires an MD5-encrypted password for authentication from all of its clients.This file is located in the same folder as nf. Open the pg_hba.conf configuration file.If the password encryption method specified on this line is other than md5, change it to md5. Password_encryption = md5 # md5 or scram-sha-256 For PostgreSQL Version 13 or later, find the following line in nf:.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.Here %postgresql_dir% (for example, C:\Program Files\PostgreSQL\11) is the folder that PostgreSQL was installed in. This file is located at %postgresql_dir%\data. Visit to see a list of supported operating systems and download the installer. Installing and configuring PostgreSQL (Windows)