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: [EMAIL PROTECTED]
> Description: Name resolution connecting to a database > trying to connect to the server with domain name > takes long time, here an example: > [EMAIL PROTECTED]:~$ 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
