Content-Type: text/plain;
  charset="us-ascii"
From: Wei Weng <wweng@cs.columbia.edu>
To: pgsql-sql@postgresql.org
Subject: What's wrong with this identification configuration?
Date: Tue, 11 Feb 2003 16:26:01 -0500
User-Agent: KMail/1.4.1
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200302111626.01386.wweng@cs.columbia.edu>

This is the idenfication setup in my /var/lib/pgsql/data/pg_hba.conf

local   all                                             trust
host    all     127.0.0.1       255.255.255.255         trust

This is supposed to authenticate any user to be able to access my postgresq=
l=20
system any time, no?

But this is what happened:

[root@Monet wweng]# su postgres
bash-2.05a$ psql template1
psql: FATAL 1:  No pg_hba.conf entry for host localhost, user postgres,=20
database template1

bash-2.05a$ exit
[root@Monet wweng]# psql template1
psql: FATAL 1:  No pg_hba.conf entry for host localhost, user root, databas=
e=20
template1

[root@Monet wweng]# exit
[wweng@Monet wweng]$ psql template1
psql: FATAL 1:  No pg_hba.conf entry for host localhost, user wweng, databa=
se=20
template1

Why is this happening? And how can I log in the template1 database?

I am using postgresql 7.2.3 on Redhat 7.3.

bash-2.05a$ rpm -qa | grep postgresql
postgresql-7.2.3-5.73
postgresql-libs-7.2.3-5.73
postgresql-server-7.2.3-5.73
postgresql-devel-7.2.3-5.73

Thanks a lot!


Wei