[Pkg-postgresql-public] Bug#703806: postgresql: failed to start: couldn't create TCP/IP Sockets

[Christian Meyer]

Hi Christoph,

Am Donnerstag, den 18.04.2013, 13:09 +0200 schrieb Christoph Berg:
> 
> Re: Christian Meyer 2013-03-23 <20130323215007.30074.7076.reportbug at Imperator>
> > The logfile says that IPv4 Socket couldn't be bound and asks wheather an other
> > postmaster is running on port 5432:
> > 2013-03-23 22:26:32 CET LOG:  konnte IPv4-Socket nicht binden: Die angeforderte
> > Adresse kann nicht zugewiesen werden
> > 
> > # netstat -an | grep 5432
> > #
> 
> Hi Christian,
> 
> Thanks for the report. Is it still reproducible?

Yes, it is.


> What does "localhost" resolve to for you? What's the output of "getent
> hosts localhost" and "host localhost"?

# cat /etc/hosts | grep localhost
127.0.0.1	localhost
::1     ip6-localhost ip6-loopback

# getent hosts localhost
127.0.0.1       localhost

# host localhost
;; Warning: Message parser reports malformed message packet.
localhost has address 127.0.0.1
Host localhost not found: 3(NXDOMAIN)
Host localhost not found: 3(NXDOMAIN)

Sorry, I have no glue what this warning means or how to fix it.

# ping localhost
PING localhost (127.0.0.1) 56(84) bytes of data.

So localhost seems to resolve to 127.0.0.1


> Does the problem go away if you change listen_addresses in the config?

I changed the file /etc/postgresql/9.1/main/postgresql.conf :
before:
#listen_addresses = 'localhost'		# what IP address(es) to listen on;

Test 1 (Problem still persists):
listen_addresses = '127.0.0.1'

Test 2 (Problem seems gone):
listen_addresses = '*'

Tried (et voilla):
# /etc/init.d/postgresql restart
[ ok ] Restarting PostgreSQL 9.1 database server: main.
#

Thanks for your hint. So I think it's not a problem of postgresql, but
what went wrong and where?
Anyway. Thank you. If I can anything else for you, just let me know.

Christian
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL: <http://lists.alioth.debian.org/pipermail/pkg-postgresql-public/attachments/20130419/11d88961/attachment.pgp>