On Fri, 10 Mar 2017, Adrian Klaver wrote:
That this looks like a merge of the sample file:
https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/libpq/pg_hba.conf.sample;h=6b1778a72136edf52cea56f2ab088b9449df9a48;hb=HEAD
with your additions.
Seems you have not restarted Pos
On Fri, 10 Mar 2017, Tom Lane wrote:
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
On 03/10/2017 11:50 AM, Rich Shepard wrote:
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 somet
Rich Shepard 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
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 p
On Fri, 10 Mar 2017, Tom Lane wrote:
It looks like what you have in pg_hba.conf is a raw copy of
pg_hba.conf.sample, without any of the editing that initdb normally
applies to it (to say nothing of manual adjustments you might make later).
Tom,
Actually, it has the modifications I've made o
Rich Shepard writes:
> 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 authenticatio
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
p
