postgresql 7.2b5 and vserver: statistics sockets - Mailing list pgsql-general

From
Subject postgresql 7.2b5 and vserver: statistics sockets
Date
Msg-id Pine.LNX.4.33.0201231503490.10226-100000@mail.conostix.com
Whole thread Raw
Responses Re: postgresql 7.2b5 and vserver: statistics sockets  ("Roderick A. Anderson" <raanders@tincan.org>)
Re: postgresql 7.2b5 and vserver: statistics sockets  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hello,

I'm using vserver (http://www.solucorp.qc.ca/miscprj/s_context.hc)
together with postgresql 7.2b5.

For those who aren't familiar with vserver, it is sort of a improved
chroot jail where port bindings and process signals are also restricted.

When starting postgresql in such a vserver, i get the following error :
(using strace on the postmaster)

----
getpid()                                = 6609
unlink("/var/ipfc/database//global/pgstat.stat") = -1 ENOENT (No such file
or directory)
socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) = 5
bind(5, {sin_family=AF_INET, sin_port=htons(0),
sin_addr=inet_addr("127.0.0.1")}}, 16) = -1 EADDRNOTAVAIL (Cannot assign
requested address)
dup(2)                                  = 6
fcntl64(0x6, 0x3, 0x6, 0)               = 32770
fstat64(6, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 2), ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0x40018000
_llseek(6, 0, 0xbfffeca0, SEEK_CUR)     = -1 ESPIPE (Illegal seek)
write(6, "PGSTAT: bind(2): Cannot assign r"..., 49PGSTAT: bind(2): Cannot
assign requested address
) = 49
close(6)                                = 0
----

so the bind on address 127.0.0.1 (for the statistics process) is not
allowed (which is correct).  How can I change this value ? (If no other
possibility is available, I'm going to change the source)

Best regards,
Tycho Fruru

--
Tycho Fruru            tycho.fruru@conostix.com
Users' impressions of different operating systems, expressed as emoticons:
Linux:   :)
Windows: XP





pgsql-general by date:

Previous
From: Dmitry Alyabyev
Date:
Subject: Re: Permissions on non-owned database
Next
From: "Roderick A. Anderson"
Date:
Subject: Re: postgresql 7.2b5 and vserver: statistics sockets