| 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: | Pine.LNX.4.10.10101301202240.12716-100000@alice.bombay.retortsoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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.
Regrds,
Milind.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | lbottorff | 2001-01-30 22:51:03 | When is a constraint too big? |
| Previous Message | Tom Lane | 2001-01-29 18:26:53 | Re: pg_hba.conf question |