From: Pietro <bpietro@simail.it>
To: pgsql-admin@postgresql.org
Subject: Re: Resolved - LAN connection to server only after restart server
Date: Tue, 29 Apr 2008 10:22:22 +0200
Message-ID: <200804291022.22605.bpietro@simail.it> (raw)
In-Reply-To: <17513.1205422296@sss.pgh.pa.us>
References: <200803131020.07510.bpietro@simail.it>
<17513.1205422296@sss.pgh.pa.us>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bpietro@simail.it
Subject: Re: Resolved - LAN connection to server only after restart server
In-Reply-To: <200804291022.22605.bpietro@simail.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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