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

From Pietro
Subject Re: Resolved - LAN connection to server only after restart server
Date
Msg-id 200804291022.22605.bpietro@simail.it
Whole thread Raw
In response to Re: LAN connection to server only after restart server  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Resolved - LAN connection to server only after restart server
List pgsql-admin
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.

Regards
Pietro

pgsql-admin by date:

Previous
From: "Phillip Smith"
Date:
Subject: Re: remove my name from mailing list
Next
From: Carol Walter
Date:
Subject: Error on pg_dumpall