CV8 doesn't see postgres?

Question

PostgreSQL

Hello, the question is this, I took a test solution, ala "POSTGRES 1C" in which the ru.RU locales and in 8.3.18.1363 1C, he simply does not want to create a database, even his own, through a checkmark, but at the same time I connect. They have a problem in locales and for some reason others choose "nizya" and they simply do not exist.
I thought about it and installed the usual postgres, but now I can’t connect to each other on the local network.
psql 13.2 & 1c 8.3.18.1363 It simply
writes "authentication method 10 not supported", and all the data is entered correctly, I work in the console and through PG too. services are also running (obviously)

pg_hba

# TYPE DATABASE USER ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all md5
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
local replication all md5
host replication all 127.0.0.1/32 md5
host replication all ::1/128 md5

In the config itself there is "*"
Perhaps you need to install some add-ons to 1C "type" ODBC or something like that?
I just watched even ordinary videos on YT and everything is done there in two clicks, but not with me ...)
upd: and yes, I do it in the window, people don’t want to switch to Linux, it’s too difficult for them.

Answer 1

To fix the "authentication method 10 not supported" error, when connecting registration (creating) database 1c, try the following steps:
1) In the configuration file postgresql.conf, adjust the password_encryption setting to md5 instead of scram-sha-256
password_encryption = md5 # scram-sha-256 or md5
2) Restart the postgresql service
3) Set (Update) the password of the user under which the connection to postgresql is configured. Below is an example for postgres user

su - postgres
/usr/pgsql-14/bin/psql -E
alter user postgres with password 'new_password';