CentOS Stream 8
Sponsored Link

PostgreSQL 12 : Remote Connection
It's possible to connect to PostgreSQL Server only from Localhost by default like here,
but if you'd like to connect to PostgreSQL from Remote hosts, change settings like follows.
[1] There are many authentication methods on PostgreSQL, though.
On this examaple, Configure MD5 password method.
[root@www ~]#
vi /var/lib/pgsql/data/postgresql.conf
# line 59 : uncomment and change

# if listens only IPv4, set ''

listen_addresses = '
[root@www ~]#
vi /var/lib/pgsql/data/pg_hba.conf
# add to the end

# TYPE  DATABASE        USER            ADDRESS                 METHOD
# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
host    all             all               ident
# IPv6 local connections:
host    all             all             ::1/128                 ident
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     all                                     peer
host    replication     all               ident
host    replication     all             ::1/128                 ident
# specify network range you allow to connect on [ADDRESS] section
# if allow all, specify []
host    all             all                md5

[root@www ~]#
systemctl restart postgresql

[2] If Firewalld is running, allow PostgreSQL service.
[root@www ~]#
firewall-cmd --add-service=postgresql --permanent

[root@www ~]#
firewall-cmd --reload

[3] To connect to a PostgreSQL Database with MD5 password, set password for each PostgreSQL user.
# connect to own database

[cent@www ~]$
psql -d testdb

psql (12.7)
Type "help" for help.

# set or change own password
testdb=> \password
Enter new password:
Enter it again:
testdb=> \q

# also possible to set or change password for any users with PostgreSQL admin user

[postgres@www ~]$
psql -c "alter user cent with password 'password';"

[4] Verify settings to connect to PostgreSQL Database with MD5 password from remote hosts.
[root@node01 ~]#
psql -h www.srv.world -d testdb -U cent

Password for user cent:   # password
psql (12.7)
Type "help" for help.

testdb=> # connected
Matched Content