On 05/03/2010 01:52 PM, Tom Lane wrote:
> Yeb Havinga<yebhavinga(at)gmail(dot)com> writes:
>>> 2010-05-03 03:36:06 UTC LOG: could not bind IPv4 socket: Cannot assign
>>> requested address
> Does it work if you change listen_addresses to '*' or '127.0.0.1' ?
Bingo - changing it to "*" got it started. :)
>>> ..and localhost is resolving...
>>> root(at)coolnewserver:~# nslookup localhost
> nslookup isn't a terribly reliable way to check that. Try "dig".
Dig seemed to return "localhost" OK...
me(at)coolnewserver:~$ dig localhost
; <<>> DiG 9.7.0-P1 <<>> localhost
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 18467
;; flags: qr aa rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 1, ADDITIONAL: 1
;; QUESTION SECTION:
;localhost. IN A
;; ANSWER SECTION:
localhost. 604800 IN A 127.0.0.1
;; AUTHORITY SECTION:
localhost. 604800 IN NS localhost.
;; ADDITIONAL SECTION:
localhost. 604800 IN AAAA ::1
;; Query time: 0 msec
;; SERVER: 220.127.116.11#53(18.104.22.168)
;; WHEN: Mon May 3 13:57:54 2010
;; MSG SIZE rcvd: 85
Could this possibly be related to IPv6? I know with this version of
Ubuntu (10.04), there's a known issue with LightTPD if you include the
IPv6 library in the configuration file (which is on by default - heh);
if you comment them out, it works just fine.
Thanks for the help!
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2010-05-03 14:20:49|
|Subject: Re: Ubuntu 10.04 - Cannot Create TCP/IP Sockets |
|Previous:||From: Tom Lane||Date: 2010-05-03 13:58:31|
|Subject: Re: Autovacuum stopped running |