[Pkg-postgresql-public] Bug#724573: postgresql: postgresql init could not create IPv4 socket. permission denied

[Christoph Berg]

Re: John Proios 2013-10-08 <5253A539.2050107 at snigel.gr>
> Tnks Christoph for reply
> 
> Selinux is not active.
> 
> The configuration is the default one. It is a typical installation of
> postgres. I think the problem lies in the after deb rules

Hi John,

could you try the following, while postgresql is stopped:

sudo -u postgres strace /usr/lib/postgresql/9.1/bin/postgres -D /etc/postgresql/9.1/main

It should output something like this:

socket(PF_INET6, SOCK_STREAM, IPPROTO_IP) = 3
setsockopt(3, SOL_SOCKET, SO_REUSEADDR, [1], 4) = 0
setsockopt(3, SOL_IPV6, IPV6_V6ONLY, [1], 4) = 0
bind(3, {sa_family=AF_INET6, sin6_port=htons(5432), inet_pton(AF_INET6, "::1", &sin6_addr), sin6_flowinfo=0, sin6_scope_id=0}, 28) = 0
listen(3, 208)                          = 0
socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 4
setsockopt(4, SOL_SOCKET, SO_REUSEADDR, [1], 4) = 0
bind(4, {sa_family=AF_INET, sin_port=htons(5432), sin_addr=inet_addr("127.0.0.1")}, 16) = 0
listen(4, 208)                          = 0

If bind() fails, you need to investigate which resource/permission
setting in your kernel is responsible for this.

Christoph
-- 
cb at df7cb.de | http://www.df7cb.de/