From: Daniel J. Summers <daniel.lists@djs-consulting.com>
To: pgsql-admin@postgresql.org
Subject: Re: Ubuntu 10.04 - Cannot Create TCP/IP Sockets
Date: Mon, 03 May 2010 14:04:18 +0000
Message-ID: <4BDED7E2.5060304@djs-consulting.com> (raw)
In-Reply-To: <14337.1272894755@sss.pgh.pa.us>
References: <4BDE46F4.4070401@djs-consulting.com>
<1CA7FF980DA3824F9A5C31532B7A40DCCDCE01FD@LCXCLMB01.LCDS.LOC.GOV>
<4BDEC707.1090403@gmail.com>
<14337.1272894755@sss.pgh.pa.us>
On 05/03/2010 01:52 PM, Tom Lane wrote:
> Yeb Havinga<yebhavinga@gmail.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@coolnewserver:~# nslookup localhost
>>>
> nslookup isn't a terribly reliable way to check that. Try "dig".
>
Dig seemed to return "localhost" OK...
me@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: 173.203.4.8#53(173.203.4.8)
;; 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!
Daniel
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: daniel.lists@djs-consulting.com
Subject: Re: Ubuntu 10.04 - Cannot Create TCP/IP Sockets
In-Reply-To: <4BDED7E2.5060304@djs-consulting.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox