Обсуждение: authentication error
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
On Tue, May 13, 2003 at 22:29:04 -0700, jie zhang <jie@best.com> 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
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/