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