Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1B25D2E0140 for ; Thu, 13 Mar 2008 06:29:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 17672-01-8 for ; Thu, 13 Mar 2008 06:29:05 -0300 (ADT) X-Greylist: delayed 00:08:48.259143 by SQLgrey-1.7.5 Received: from smtp-out3.libero.it (smtp-out3.libero.it [212.52.84.43]) by postgresql.org (Postfix) with ESMTP id 0ECCA2E2FD1 for ; Thu, 13 Mar 2008 06:29:04 -0300 (ADT) Received: from outrelay08.libero.it (192.168.32.103) by smtp-out3.libero.it (7.3.120) id 4628C87A0814ADF7 for pgsql-admin@postgresql.org; Thu, 13 Mar 2008 10:20:13 +0100 X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AqABAJ6O2EeXSXu6/2dsb2JhbAAIplk Received: from unknown (HELO [192.168.1.2]) ([151.73.123.186]) by OutRelay-b08.libero.it with ESMTP; 13 Mar 2008 10:20:13 +0100 From: Pietro To: pgsql-admin@postgresql.org Subject: LAN connection to server only after restart server Date: Thu, 13 Mar 2008 10:20:07 +0100 User-Agent: KMail/1.9.7 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200803131020.07510.bpietro@simail.it> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200803/104 X-Sequence-Number: 28587 Hi, I have strange behaviour on my LAN. Postgresql server is up and running, accepting connection on default port. Firewall is set well. Connection from 'localhost' is OK. Connection from another host on LAN is refused (sniffed with wireshark: request ACK, response RST, ACK) and so application shows 'Can't connect to DB server' and dies. After restart Postgresql server, nota bene _WITHOUT_ changing any bit of configuration files, all stuff work (connections from localhost and connections from LAN too) In /etc/rc5.d/ postgresql server is started after network and after firewall. 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. All boxes runs Mandriva 2008.0 Any clue? Thanks in advance Pietro