Cott Lang <cott@xxxxxxxxxxxxxxxxx> writes: >> What exactly does >> "would not accept" mean --- what was the exact error message, >> and was there anything in the postmaster log? > There was nothing in the postmaster log indicating a problem. > The only thing I saw strange was multiple postmasters spawning and > disappearing. > The errors I got in the JDBC drivers was the connection pool timing out > trying to get a connection, so it's possible they were working, just > taking horribly long to connect. Timeouts for Nagios monitoring PG was > 10 seconds; pools were 20 seconds. In that case, the "multiple postmasters" were probably backends spawned in response to JDBC connection attempts, which went away when they noticed the client had disconnected. These symptoms seem consistent with the idea that backend startup was taking a real long time, which given the context has to be blamed on a DNS lookup timing out. Do you have log_hostname enabled? If so, the backends would be trying to do reverse lookups on the IP address of their connected client, and we could explain all the facts with the assumption that that lookup was encountering a 30-second-or-so timeout. Why this should be happening after you change resolv.conf isn't real clear to me, but in any case if you have a gripe about it you should gripe to your libc or libbind supplier, not us. Whatever the problem is, it's down inside the getnameinfo() library routine. regards, tom lane
