Project

General

Profile

« Previous | Next » 

Revision 11451

bugfix: schemas/pg_hba.conf: don't allow ident authentication for Unix socket connections, because this apparently prevents having normal, password-based connections ("md5"). note that just switching the order of the ident and md5 entries is not useful, because whichever authentication type comes second will be ignored completely. this problem was previously worked around by just not using Unix socket connections at all, and always specifying "localhost" as the host to force a hostname-based connection. this does not affect the postgres superuser, because they have their own ident line in pg_hba.conf.

View differences:

pg_hba.conf
95 95
host    template1,vegbien  public_ 0.0.0.0/0 trust
96 96
host    template1,vegbien  public_ ::/0      trust
97 97

  
98
local   all                +bien            ident
99 98
local   all                +bien            md5
100 99
host    all                +bien  0.0.0.0/0 md5
101 100
host    all                +bien  ::/0      md5

Also available in: Unified diff