Skip site navigation (1) Skip section navigation (2)

Changing auth type in pg_hba.conf ineffective. Why?

From: Bryce Nesbitt <bryce1(at)obviously(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Changing auth type in pg_hba.conf ineffective. Why?
Date: 2005-11-24 21:18:30
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
I'm struggling to resolve a login error.  It seems that I'm getting
"ident" authentication, no mater what I set pg_hba.conf to.  Here's a
log file:

  LOG:  next transaction ID: 602; next OID: 17232
  LOG:  database system is ready
  FATAL:  Ident authentication failed for user "bryce"
  LOG:  could not connect to Ident server at address "::1", port 113:
Connection refused

This makes sense, because no identd is running, and port 113 is blocked
anyway.  So I need another auth method.
My relevant pg_hba.conf lines are:

  #local   all         all                               ident sameuser
  #host    all         all          ident sameuser
  #host    all         all         ::1/128               ident sameuser
  local   all         all                               md5
  host    all         all            trust
  host    all         all         ::1/128               md5

I've renamed pg_hba.conf temporarily, just to verify that postmaster
won't start without it.  So I'm editing the right file, and restarting
postmaster correctly.  Any clues why I'm still getting 'auth' method

I'm using JDBC (Java Database Connection)
PostgreSQL version 8.0.3
SUSE Linux 10.0


pgsql-sql by date

Next:From: Bath, DavidDate: 2005-11-24 22:57:11
Subject: Updatable views: any decent front-ends?
Previous:From: Mauricio Fernandez A.Date: 2005-11-24 18:43:28
Subject: does indexes need statistics?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group