configuration

created onJanuary 11, 2022
last modified onAugust 27, 2025

enable postgresql server to listen on all addresses

Out of the box, the postgresql server listens to localhost / 127.0.0.1 In order to make the server listen to all addresses on the machine, in postgresql.conf, replace with or supply the complete list of IPs, like i.e. .

enable scram-sha-256 for password hashing

if your PostgreSQL configuration still uses md5 for password hashing, the config should be changed to use scram-sha-256 for password hashing in postgres.conf with

x