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
