pg_hba.conf problem

From: David Nedrow <listbox(at)nedron(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_hba.conf problem
Date: 2003-11-30 18:53:58
Message-ID: 8E445654-2366-11D8-A0AA-003065B331C2@nedron.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to set up the cyrus imap server using PostgreSQL as the
authentication backend.

Currently, the issue I'm having is that I'm unable to connect via psql
on the loopback address (127.0.0.1).

I believe I have the pg_hba.conf file correct, though I've tried a
number of variations other than what I've included below. After each
change to pg_hba.conf, I bounce postgresql (stop start), but still get
a FATAL error re: missing entries for 127.0.0.1.

I'm stumped. I'm probably missing something simple, but I've looked at
a number of samples on usenet and in the PostgreSQL doco, but I haven't
been able to clear this up.

pg_hba.conf
===========

local all all ident sameuser
host all all 127.0.0.1/32 password

command and error
=================

[root(at)netfinity root]# psql mail -U mail -W -h 127.0.0.1 <
/var/www/html/web-cyradm-0.5.3-1/scripts/create_pgsql.sql
Password: *********
psql: FATAL: No pg_hba.conf entry for host 127.0.0.1, user mail,
database mail

[root(at)netfinity root]#

Any ideas?

-David

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-11-30 18:56:06 Re: export FUNC_MAX_ARGS as a read-only GUC variable (was: [GENERAL] SELECT Question)
Previous Message Peter Eisentraut 2003-11-30 18:46:46 Re: Making pg_dump cvs friendly