pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: Resolved - LAN connection to server only after restart server
2+ messages / 2 participants
[nested] [flat]

* Re: Resolved - LAN connection to server only after restart server
@ 2008-04-29 08:22  Pietro <bpietro@simail.it>
  0 siblings, 1 reply; 2+ messages in thread

From: Pietro @ 2008-04-29 08:22 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Resolved - LAN connection to server only after restart server
@ 2008-05-05 00:02  Lew <lew@lwsc.ehost-services.com>
  parent: Pietro <bpietro@simail.it>
  0 siblings, 0 replies; 2+ messages in thread

From: Lew @ 2008-05-05 00:02 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2008-05-05 00:02 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-04-29 08:22 Re: Resolved - LAN connection to server only after restart server Pietro <bpietro@simail.it>
2008-05-05 00:02 ` Lew <lew@lwsc.ehost-services.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox