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.an@sitvallee.it

> Description:        Name resolution connecting to a database

> trying to connect to the server with domain name
> takes long time, here an example:
> nino@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