Rich Shepard <rshepard@xxxxxxxxxxxxxxx> writes: > Postgres runs on my desktop server/workstation and I'm the only user > loggin in. Here's pg_hba.conf (restored from 2-22-2017 backup) which still > does not work. I've read the pg_hba.conf section in the 9.6 docs without > seeing what's wrong with my file. > # PostgreSQL Client Authentication Configuration File > # =================================================== > # Put your actual configuration here > # ---------------------------------- > @authcomment@ > # TYPE DATABASE USER ADDRESS METHOD > @remove-line-for-nolocal@# "local" is for Unix domain socket connections only > @remove-line-for-nolocal@local all all @authmethodlocal@ > # IPv4 local connections: > local all rshepard trust > host all rshepard 127.0.0.1/32 trust > hostnossl all rshepard 127.0.0.1/32 trust > # IPv6 local connections: > host all all ::1/128 @authmethodhost@ > # Allow replication connections from localhost, by a user with the > # replication privilege. > @remove-line-for-nolocal@#local replication @default_username@ @authmethodlocal@ > #host replication @default_username@ 127.0.0.1/32 @authmethodhost@ > #host replication @default_username@ ::1/128 @authmethodhost@ > What am I not seeing? The "@remove-line-for-nolocal@" bits should not be there. initdb would normally either delete those lines entirely, or strip off "@remove-line-for-nolocal@", depending on the switches it was given. Likewise the various other @something@ bits should have been changed to something else. It certainly wasn't working before if it was like this, either. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
