Добрый день, не получается удаленно залогиниться в постгрес (локально). Сам постгрес висит на хосте 192.168.252.10 подключаюсь с 192.168.252.16. Конфиги: pg_hba.conf Добавлял последнюю строчку.
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust
# Allow replication connections from localhost, by a user with the
# replication privilege.
local replication all peer
host replication all 127.0.0.1/32 ident
host replication all ::1/128 ident
host all all 192.168.252.0/24 md5
listen_addresses = '*' # what IP address(es) to listen on;
Подключаюсь так:
psql --host=192.168.252.10 --port=5432 --username=user --password --dbname=db
psql: FATAL: password authentication failed for user
