Hi.
On Thu, Jul 30, 2009 at 7:33 PM, Tom Lane<tgl@sss.pgh.pa.us> wrote:
> Dotan Barak <dotanba@gmail.com> writes:
>> The weird thing is that i used this port in a service that i wrote
>> only few seconds before this happened...
>
> Oh? How'd you start that service exactly?
>
> I'm thinking maybe the postmaster inherited the open file from its
> parent process. If it's not marked close-on-exec, which evidently
> it's not since the child processes have it too, then this could have
> happened as far as Postgres itself is concerned. I'm having a bit of
> a hard time imagining how an open file could have gotten transmitted
> from some other initscript to this one, but it seems more probable
> than any other theory at the moment.
>
> Do any other processes besides PG have that socket open? If you stop
> and restart the postmaster, does it open the socket again?
I guess you hit the spot: I have a service that I wrote in python
which uses port 17583.
This process restart the postgres SQL service using
"/etc/init.d/postgres restart"
I think that this may be related to this problem ...
I will mark the socket as close on exec.
Thanks!!!!
Dotan