Re: authentication error

From: "eladio rodriguez" <elarod_ad(at)hotmail(dot)com>
To: jie(at)best(dot)com, pgsql-admin(at)postgresql(dot)org
Subject: Re: authentication error
Date: 2003-05-16 20:12:25
Message-ID: Law14-F61PLkeNq4I6100022814@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)best(dot)com>
>To: pgsql-admin(at)postgresql(dot)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/

Browse pgsql-admin by date

  From Date Subject
Next Message Shankar K 2003-05-16 21:10:52 overflow on numeric ABS(value) >= 10^2
Previous Message Kuhn, Dylan K (4520500D) 2003-05-16 19:07:35 Re: bulk DELETE speed