Re: PG quitting sporadically!!

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>, gsmith(at)gregsmith(dot)com
Subject: Re: PG quitting sporadically!!
Date: 2008-02-15 20:12:14
Message-ID: 20080215201214.GF22581@alvh.no-ip.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches

Phoenix Kiula escribió:
> Thanks. Comments below. (PS: I am still unable to connect to
> postgresql even in SSH! I see this message:
>
> psql: could not connect to server: Connection timed out
> Is the server running on host "localhost" and accepting
> TCP/IP connections on port 5432?
>
> Yes of course the localhost is running the pgsql server and that port
> is allowed!

My educated guess is that your network is behaving funny, or your
firewall is crazy. Or your kernel has bugs. The fact that the
connections work sometimes is one clue; this is the other:

> LOG: test message did not get through on socket for statistics collector
> LOG: disabling statistics collector for lack of working socket

This is a bad sign. For one thing, it means autovacuum, if enabled, is
not really working at all (which can, in turn, explain slowness).

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tony Caduto 2008-02-15 20:49:26 Re: Pains in upgrading to 8.3
Previous Message Scott Marlowe 2008-02-15 19:43:30 Re: Approaches for Lookup values (codes) in OLTP application

Browse pgsql-patches by date

  From Date Subject
Next Message Greg Smith 2008-02-15 21:36:57 Re: PG quitting sporadically!!
Previous Message Brendan Jurd 2008-02-15 03:13:33 Re: Key for grant attributes (was: Re: Show INHERIT in \du)