authentication error

Поиск
Список
Период
Сортировка
Искать

authentication error

От:
jie zhang <jie@best.com>
Дата:
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 ?
Please advice if you can.  

thanks in advance,

Jie


Re: authentication error

От:
Bruno Wolff III <bruno@wolff.to>
Дата:
On Tue, May 13, 2003 at 22:29:04 -0700,
  jie zhang  wrote:
> 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

It looks like you are connecting via domain sockets and have not allowed
this for any users in pg_hba.conf. You probably want to change the local
line to:
local all trust

> 
> 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 ?
> Please advice if you can.  
> 
> thanks in advance,
> 
> Jie
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org

Re: authentication error

От:
"eladio rodriguez" <elarod_ad@hotmail.com>
Дата:
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 
>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/

FAQ