Comments on: How To Configure PostgreSQL to Allow Remote Connections https://tecadmin.net/postgresql-allow-remote-connections/ How to guide for System Administrator's and Developers Wed, 16 Nov 2022 05:48:44 +0000 hourly 1 https://wordpress.org/?v=6.1.1 By: Sergey https://tecadmin.net/postgresql-allow-remote-connections/#comment-64301 Tue, 14 Jun 2022 16:34:37 +0000 https://tecadmin.net/?p=27027#comment-64301 As Faheem Ahmed mentioned in your article an error for the ipv6 address. The better version that uses scram-sha-256 instead of md5 :

# IPv4 local connections:
host all all 0.0.0.0/0 scram-sha-256
# IPv6 local connections:
host all all ::/0 scram-sha-256

]]> By: Faheem Ahmed https://tecadmin.net/postgresql-allow-remote-connections/#comment-63700 Mon, 03 Jan 2022 13:14:08 +0000 https://tecadmin.net/?p=27027#comment-63700 I think the following line might cause issues
host all all :/0 md5

The configuration to allow on IPv6 should be like:
host all all ::0/0 md5

]]>