On Fri, 10 Mar 2017, Rich Shepard wrote:
Actually, it has the modifications I've made over the years. That's why I could not see what changed.
Well, postgres was running yesterday and allowed me to access my bookkeeping software so obviously something did change without my manually editing pg_hba.conf. Here are the log records: LOG: could not open secondary authentication file "@authcomment@" as "/var/lib/pgsql/9.6/data/authcomment@": No such file or directory LOG: could not open secondary authentication file "@remove-line-for-nolocal@" as "/var/lib/pgsql/9.6/data/remove-line-for-nolocal@": No such file or directory LOG: could not open secondary authentication file "@remove-line-for-nolocal@local" as "/var/lib/pgsql/9.6/data/remove-line-for-nolocal@local": No such file or directory LOG: could not open secondary authentication file "@authmethodlocal@" as "/var/lib/pgsql/9.6/data/authmethodlocal@": No such file or directory LOG: could not open secondary authentication file "@authmethodhost@" as "/var/lib/pgsql/9.6/data/authmethodhost@": No such file or directory LOG: could not open secondary authentication file "@remove-line-for-nolocal@" as "/var/lib/pgsql/9.6/data/remove-line-for-nolocal@": No such file or directory LOG: invalid connection type "all" CONTEXT: line 80 of configuration file "/var/lib/pgsql/9.6/data/pg_hba.conf" LOG: end-of-line before authentication method CONTEXT: line 86 of configuration file "/var/lib/pgsql/9.6/data/pg_hba.conf" FATAL: could not load pg_hba.conf LOG: database system is shut down 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? Rich -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
