PostgreSQL access over the local network.

Posted on by

After installing postgresql

Edit the pg_hba.conf
usually

/var/lib/pgsql/data/

under the line

# TYPE DATABASE USER ADDRESS METHOD

comment out all the lines using #
and then add

host all all 127.0.0.1/32 trust

and

host all all 192.168.0.0/24 trust

and that seems to work. I can log in to the server over my local network using DataGrip.