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

[Christian Meyer]

Hi Christoph

Am Freitag, den 26.04.2013, 19:45 +0200 schrieb Christoph Berg:
> Re: Christian Meyer 2013-04-19 <1366407520.13657.15.camel at Imperator>

> > # 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)

> Could you try "options single-request" in /etc/resolv.conf to see if
> that fixes the problem with "host localhost" and PostgreSQL?

Thats a bit tricky since network-manager overwrites /etc/resolv.conf .
I changed the file and did only a /etc/init.d/networking restart but the
output of 'host localhost' is unchanged.


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

> Not sure if I read that correctly, did you mean that "Test 1" was
> still done with "localhost", and "Test 2" was with 127.0.0.1 and the
> problem was gone?

No, I meant it that way:
localhost -> problem occurs
127.0.0.1 -> problem occurs
* -> problem is gone


After your hint of missing localhost resolution and rethinking various
times about it I now belive that this is the point. Perhaps
network-manager (or something else ?) messed up with the configuration:

* BOINC Manager is not able to connect to localhost, too (and it never
was before).

* Some time ago I configured cups and was able to connect to it via
http://localhost:631/ but during examinating things here, I now can not
connect to it any longer. Neither as localhost nor 127.0.0.1 nor the
local network IPv4 adress.

* 'ping localhost' resolves to 127.0.0.1 but has 100% Packet loss

* 'ping6 localhost' returns 'unknown host'

For me only three questions remain:
1. Why does your sloution work with listen_addresses = '*' ?
2. What caused the problem?
3. How to fix the localhost resolution? (But this shure is my problem,
not yours ;-)  )


Thank you,
Christian



# cat /etc/resolv.conf
options single-request
# Generated by NetworkManager
domain Speedport_W_700V
search Speedport_W_700V
nameserver 192.168.2.1


# cat /etc/host.conf 
multi on


# cat /etc/hosts
127.0.0.1	localhost
127.0.1.1	Imperator

# The following lines are desirable for IPv6 capable hosts
::1     ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters

-------------- 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/20130427/b744ec04/attachment.pgp>