Re: Resolved - LAN connection to server only after restart server

From: Lew <lew(at)lwsc(dot)ehost-services(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Resolved - LAN connection to server only after restart server
Date: 2008-05-05 00:02:31
Message-ID: iaSdnbrYXN8K04PVnZ2dnUVZ_uGdnZ2d@comcast.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Pietro wrote:
> At Thursday 13 March 2008 16:31:36 Tom Lane wrote:
>> Pietro <bpietro(at)simail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Patrick Roberts 2008-05-05 04:36:12 restore postgres system database 8.1.11
Previous Message Andrew Sullivan 2008-05-02 20:41:52 Re: 8.1.8 autovacuum missing databases