Fedora 35
Sponsored Link

PostgreSQL 14 : Remote Connection
It's possible to connect to PostgreSQL Server only from Localhost by default like here,
however 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 60 : uncomment and change
# if listen only IPv4, specify ''

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

[root@www ~]#
firewall-cmd --runtime-to-permanent

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

[fedora@www ~]$
psql -d testdb

psql (14.0)
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

psql -c "alter user fedora 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 fedora

Password for user fedora:   # password
psql (14.0)
Type "help" for help.

testdb=> # connected
Matched Content