Re: Resolved - LAN connection to server only after restart server - Mailing list pgsql-admin

From Lew
Subject Re: Resolved - LAN connection to server only after restart server
Date
Msg-id iaSdnbrYXN8K04PVnZ2dnUVZ_uGdnZ2d@comcast.com
Whole thread Raw
In response to Re: Resolved - LAN connection to server only after restart server  (Pietro <bpietro@simail.it>)
List pgsql-admin
Pietro wrote:
> At Thursday 13 March 2008 16:31:36 Tom Lane wrote:
>> Pietro <bpietro@simail.it> writes:
>>> It isn't so serious problem for me, only boring one, because each morning
>>> I must start server box and then manually restart posgresql server.
>
> Problem resolved:
>
> Annoying part of this problem was its intermittent character. Two days all OK,
> another one not working until restart, and so on.
> Then I discover this line of log: could not bind IPv4 socket.
> IMHO it was timing problem. Some days posgresql server was too quick and
> tryied binding while network part wasn't wake up yet.
> So I added nice 'sleep 10' in postgresql startup script and now all work well.

Thank you so very much, molto grazie, for sharing the solution with us.

--
Lew

pgsql-admin by date:

Previous
From: "Phillip Smith"
Date:
Subject: Re: restore postgres system database 8.1.11
Next
From: Chander Ganesan
Date:
Subject: Re: server crash, need to restore DB functionality