nadejnei.net

su - postgres

psql → ALTER USER postgres WITH PASSWORD '123456';

CTRL+D

Вышел в root#

cd /var/lib/pgsql/data

vim vim postgresql.conf

раскомментировал:

listen_addresses = '*' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost'; use '*' for all
# (change requires restart)
port = 5432

vim pg_hba.conf добавил

host all all 10.10.101.0/24 trust
systemctl restart postgresql