Skip site navigation (1) Skip section navigation (2)

Re: pg_hba.conf question

From: Milind Patil <milind(at)bombay(dot)retortsoft(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Graham Vickrage <graham(at)digitalplanit(dot)com>, Postgres Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg_hba.conf question
Date: 2001-01-30 06:35:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

On Mon, 29 Jan 2001, Tom Lane wrote:

> "Graham Vickrage" <graham(at)digitalplanit(dot)com> writes:
> > After trying the usual command %psql dbname to connect I keep getting the
> > message
> > No pg_hba.conf entry for host localhost, user postgres, database dbname
> Looks to me like you're trying to connect via Unix-socket.  Try
> specifying PGHOST=localhost at the client.
> 			regards, tom lane

Well , it seems Ur editing wrong file.

If Ur working on postgres 6.5 edit the file pg_hba.conf file in pgsql dir

however if Ur working on postgres 7 edit file pg_hba.conf file in
pgsq/data dir and locate other pg_hba.conf file if exists and rename them.

Check this out.



In response to

pgsql-admin by date

Next:From: lbottorffDate: 2001-01-30 22:51:03
Subject: When is a constraint too big?
Previous:From: Tom LaneDate: 2001-01-29 18:26:53
Subject: Re: pg_hba.conf question

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group