I've tried resolving this but do not see what changed. 1. Shut down postgres: pg_ctl stop -D /var/lib/pgsql/9.6/data 2. Upgraded version (using SlackBuilds.org package as usual). 3. Tried re-starting postgres: postgres@salmo:~$ postgres -D /var/lib/pgsql/9.6/data/ & [1] 17585 postgres@salmo:~$ 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 "@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" FATAL: could not load pg_hba.conf LOG: database system is shut down 4. Line 80 in pg_hba.conf: @remove-line-for-nolocal@local all all @authmethodlocal@ 5. Tried commenting out that line to match backup, but that also did not allow postgres to start. 6. All files are owned by postgres.users. Please teach me how to fix this. TIA, Rich -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
