From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Frank Miles <fpm(at)u(dot)washington(dot)edu> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: problem connecting from another host |
Date: | 2001-06-14 00:35:48 |
Message-ID: | 15329.992478948@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Frank Miles <fpm(at)u(dot)washington(dot)edu> writes:
> The error log shows:
> No pg_hba.conf entry for host abc.de.fg.hij, user fpm, database fpm
> while in the pg_hba.conf I have an entry:
> host fpm abc.de.fg.hij 255.255.255.255 trust
> (Initially it wasn't "trust", but first I want to get *some* connection).
That looks fine to me, assuming that "abc.de.fg.hij" actually stands for
the numeric IP (*not* DNS name) of the client machine.
Sometimes people are confused about what IP address they're really
connecting from, if they are running any sort of virtual IP or
multi-interface setup. Might wanna double check it. However, the
error message should show the source IP, so you probably would have
noticed already if that were it.
If you are looking only at the error message returned to the client, try
looking in the postmaster log as well. Sometimes there's extra info
written to the log.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Ian Lance Taylor | 2001-06-14 00:39:51 | Re: Log files, how to rotate properly |
Previous Message | Rob Arnold | 2001-06-13 23:42:42 | Re: abs() does not exists.. |