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 [EMAIL PROTECTED] > with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED] > -- Oliver Elphick [EMAIL PROTECTED] 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 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]