Re: authentication error - Mailing list pgsql-admin

From eladio rodriguez
Subject Re: authentication error
Date
Msg-id Law14-F61PLkeNq4I6100022814@hotmail.com
Whole thread Raw
In response to authentication error  (jie zhang <jie@best.com>)
List pgsql-admin
hi.

maybe:

# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD

local   all         all                                             password
host    all         all         XXX.X.X.X         XXX.XXX.XXX.XXX   password

good luck.


>From: jie zhang <jie@best.com>
>To: pgsql-admin@postgresql.org
>Subject: [ADMIN] authentication error
>Date: Wed, 14 May 2003 12:35:11 -0700
>
>Hi,
>
>I try to connect using psql test from localhost.  I got:
>FATAL 1:  No pg_hba.conf entry for host localhost, user postgres, database
>test
>
>I double checked that I have done the following:
>I started server using: postmaster -i -D /var/lib/pgsql/data >logfile 2>&1
>&
>
>In my pg_hba.conf file I have:
>host       all         127.0.0.1     255.255.255.0    trust
>local   all     reject
>
>Are there anything else I need to do ?  or anything I did wrong ?
>I try to force the connection go through tcp/ip.
>Please advice if you can.
>
>thanks in advance,
>
>Jie
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster

_________________________________________________________________
Charla con tus amigos en línea mediante MSN Messenger:
http://messenger.yupimsn.com/


pgsql-admin by date:

Previous
From: "Kuhn, Dylan K (4520500D)"
Date:
Subject: Re: bulk DELETE speed
Next
From: Shankar K
Date:
Subject: overflow on numeric ABS(value) >= 10^2