From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Upgradede -9.6.1 to -9.6.2; postmaster will not start |
Date: | 2017-03-10 19:50:24 |
Message-ID: | alpine.LNX.2.11.1703101142100.26081@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)local" as
"/var/lib/pgsql/9.6/data/remove-line-for-nolocal(at)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(at)# "local" is for Unix domain socket connections only
@remove-line-for-nolocal(at)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(at)#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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-03-10 19:57:00 | Re: Upgradede -9.6.1 to -9.6.2; postmaster will not start |
Previous Message | Rich Shepard | 2017-03-10 19:25:31 | Re: INSERT and ON CONFLICT |