Re: postgres: No pg_hba.conf entry for host
On Thu, 2002-09-26 at 08:51, Erik Steffl wrote:
> I get the following error message when trying to connect to postgres
> using tora:
>
> No pg_hba.conf entry for host...
>
> I think that the settings are ok since I can loging using psql:
>
> jojda:~> psql pokus -U erik -W
This is using Unix sockets, a "local" connection. Try
psql -h localhost -d pokus -U erik -W
and see what happens.
> Password:
> Welcome to psql, the PostgreSQL interactive terminal.
>
> here's my pg_hba.conf (uncommented lines):
>
> host all 0.0.0.0 0.0.0.0 reject
As soon as a matching entry is found, PostgreSQL will stop searching
pg_hba.conf. This says to reject _all_ TCP/IP connections.
> local all md5
> host all 127.0.0.1 255.0.0.0 md5
> host pokus 127.0.0.1 255.0.0.0 md5 erik
>
> it doesn't work with or without last line.
>
> any ideas?
>
> this is on debian unstable, kernel 2.4.18
>
> TIA
>
> erik
>
>
> --
> To UNSUBSCRIBE, email to debian-user-request@lists.debian.org
> with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
>
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"For I am convinced that neither death, nor life, nor
angels, nor principalities, nor things present, nor
things to come, nor powers, nor height, nor depth, nor
any other created thing, shall be able to separate us
from the love of God, which is in Christ Jesus our
Lord." Romans 8:38,39
Reply to: