From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
Cc: | 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:57:00 |
Message-ID: | 5448.1489175820@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Rich Shepard <rshepard(at)appl-ecosys(dot)com> 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(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?
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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2017-03-10 20:00:00 | Re: Upgradede -9.6.1 to -9.6.2; postmaster will not start |
Previous Message | Rich Shepard | 2017-03-10 19:50:24 | Re: Upgradede -9.6.1 to -9.6.2; postmaster will not start |