Re: BUG #1088: Name resolution connecting to a database

On Tuesday 02 March 2004 14:09, PostgreSQL Bugs List wrote:
> The following bug has been logged online:
>
> Bug reference: 1088
> Logged by: Antonino Albanese
> Email address: al(dot)an(at)sitvallee(dot)it

> Description: Name resolution connecting to a database

> trying to connect to the server with domain name
> takes long time, here an example:
> nino(at)server:~$ time psql -h server -d newtestdb -U download -c '\q'
>
> real 0m10.151s
> user 0m0.010s
> sys 0m0.000s

This looks like a problem in your DNS setup rather than PostgreSQL - the 10
minutes is a timeout. Possibly with reverse lookup. You may see similar
problems with a mailserver if you are running one (and mailserver lists are a
good place to search too).

You may want to investigate /etc/resolv.conf on both machines as well as the
dig/host commands. Don't forget it could be a problem with server A lookup up
server B or vice versa.

HTH
--
Richard Huxton
Archonet Ltd