Lists: | pgsql-admin |
---|
From: | "Senthil Kumar G" <senthil(at)zoniac(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Unable to start Statistics Collector |
Date: | 2010-06-22 15:03:56 |
Message-ID: | 011401cb121c$269abb10$1201a8c0@senthilg |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
Hi
I set it up the postgres db and wanted to enable the statistics collector in
one of our customer server. Some how, it is not running. Please see the
error below.
Can you let me know what could be the issue?
1. Error during server startup
2. On executing ps -ef |grep post, it is showing eth0 IP address. It
should be localhost IP 127.0.0.1
Regards
Senthil
From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org>,<senthil(at)zoniac(dot)com> |
Subject: | Re: Unable to start Statistics Collector |
Date: | 2010-06-22 17:12:39 |
Message-ID: | 4C20A8B7020000250003280C@gw.wicourts.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
"Senthil Kumar G" <senthil(at)zoniac(dot)com> wrote:
> I set it up the postgres db and wanted to enable the statistics
> collector in one of our customer server. Some how, it is not
> running. Please see the error below.
I am not able to view that. (I assume you embedded some image
format my OS doesn't understand.) Could you repost with text?
Before you repost, please review this for ideas on other information
which might be useful:
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
-Kevin
From: | "Senthil Kumar G" <senthil(at)zoniac(dot)com> |
---|---|
To: | "'Kevin Grittner'" <Kevin(dot)Grittner(at)wicourts(dot)gov>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Unable to start Statistics Collector |
Date: | 2010-06-23 04:52:31 |
Message-ID: | 00b401cb128f$e4f2c5d0$1201a8c0@senthilg |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
Hi
Here is the error:
2010-04-08 17:30:41 ISTLOG: could not receive test message on socket for
statistics collector: Connection refused
2010-04-08 17:30:41 ISTLOG: disabling statistics collector for lack of
working socket
Regards
Senthil
-----Original Message-----
From: Kevin Grittner [mailto:Kevin(dot)Grittner(at)wicourts(dot)gov]
Sent: Tuesday, June 22, 2010 10:43 PM
To: pgsql-admin(at)postgresql(dot)org; senthil(at)zoniac(dot)com
Subject: Re: [ADMIN] Unable to start Statistics Collector
"Senthil Kumar G" <senthil(at)zoniac(dot)com> wrote:
> I set it up the postgres db and wanted to enable the statistics
> collector in one of our customer server. Some how, it is not
> running. Please see the error below.
I am not able to view that. (I assume you embedded some image
format my OS doesn't understand.) Could you repost with text?
Before you repost, please review this for ideas on other information
which might be useful:
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
-Kevin
From: | sivakumar krishnamurthy <sivakumar(dot)mailinglist(at)gmail(dot)com> |
---|---|
To: | senthil(at)zoniac(dot)com |
Cc: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Unable to start Statistics Collector |
Date: | 2010-06-23 10:34:27 |
Message-ID: | AANLkTinSZFAb4qHsDIrR4VsrZfZ9ksJljtTijAxaVof0@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
>
> 2010-04-08 17:30:41 ISTLOG: could not receive test message on socket for
> statistics collector: Connection refused
> 2010-04-08 17:30:41 ISTLOG: disabling statistics collector for lack of
> working socket
>
> I remember having the same problem last week and after debugging found that
my loopback wasn't working.
Can you check if ping 127.0.0.1 is working if not start the loopback
interface.
Thanks,
Sivakumar.K
From: | "Senthil Kumar G" <senthil(at)zoniac(dot)com> |
---|---|
To: | "'sivakumar krishnamurthy'" <sivakumar(dot)mailinglist(at)gmail(dot)com> |
Cc: | "'Kevin Grittner'" <Kevin(dot)Grittner(at)wicourts(dot)gov>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Unable to start Statistics Collector |
Date: | 2010-06-23 11:59:26 |
Message-ID: | 017f01cb12cb$890cf560$1201a8c0@senthilg |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
Hi
I executed follows. I am able to ping.
>ping 127.0.0.1
PING 127.0.0.1 (127.0.0.1) 56(84) bytes of data.
64 bytes from 127.0.0.1: icmp_seq=1 ttl=64 time=0.052 ms
64 bytes from 127.0.0.1: icmp_seq=2 ttl=64 time=0.057 ms
64 bytes from 127.0.0.1: icmp_seq=3 ttl=64 time=0.059 ms
Please let me know what should I do next.
Regards
Senthil
_____
From: sivakumar krishnamurthy [mailto:sivakumar(dot)mailinglist(at)gmail(dot)com]
Sent: Wednesday, June 23, 2010 4:04 PM
To: senthil(at)zoniac(dot)com
Cc: Kevin Grittner; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Unable to start Statistics Collector
2010-04-08 17:30:41 ISTLOG: could not receive test message on socket for
statistics collector: Connection refused
2010-04-08 17:30:41 ISTLOG: disabling statistics collector for lack of
working socket
I remember having the same problem last week and after debugging found that
my loopback wasn't working.
Can you check if ping 127.0.0.1 is working if not start the loopback
interface.
Thanks,
Sivakumar.K
From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
---|---|
To: | "'sivakumar krishnamurthy'" <sivakumar(dot)mailinglist(at)gmail(dot)com>, <senthil(at)zoniac(dot)com> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Unable to start Statistics Collector |
Date: | 2010-06-23 13:56:36 |
Message-ID: | 4C21CC4402000025000328D3@gw.wicourts.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
"Senthil Kumar G" <senthil(at)zoniac(dot)com> wrote:
> sivakumar krishnamurthy <sivakumar(dot)mailinglist(at)gmail(dot)com> wrote:
>>> 2010-04-08 17:30:41 ISTLOG: could not receive test message on
>>> socket for statistics collector: Connection refused
>>> 2010-04-08 17:30:41 ISTLOG: disabling statistics collector for
>>> lack of working socket
>>
>> I remember having the same problem last week and after debugging
>> found that my loopback wasn't working.
>> Can you check if ping 127.0.0.1 is working if not start the
>> loopback interface.
> 64 bytes from 127.0.0.1: icmp_seq=1 ttl=64 time=0.052 ms
> 64 bytes from 127.0.0.1: icmp_seq=2 ttl=64 time=0.057 ms
> 64 bytes from 127.0.0.1: icmp_seq=3 ttl=64 time=0.059 ms
>
> Please let me know what should I do next.
Is there any sort of firewall software running on the OS of this
machine which might be blocking UDP packets?
-Kevin
From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Senthil Kumar G <senthil(at)zoniac(dot)com> |
Cc: | sivakumar krishnamurthy <sivakumar(dot)mailinglist(at)gmail(dot)com>, Kevin Grittner <kevin(dot)grittner(at)wicourts(dot)gov>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Unable to start Statistics Collector |
Date: | 2010-06-23 17:11:44 |
Message-ID: | 1277313092-sup-4662@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
Excerpts from Senthil Kumar G's message of mié jun 23 07:59:26 -0400 2010:
> Hi
>
>
>
> I executed follows. I am able to ping.
>
> >ping 127.0.0.1
So can you ping localhost?
--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
Cc: | Senthil Kumar G <senthil(at)zoniac(dot)com>, sivakumar krishnamurthy <sivakumar(dot)mailinglist(at)gmail(dot)com>, Kevin Grittner <kevin(dot)grittner(at)wicourts(dot)gov>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Unable to start Statistics Collector |
Date: | 2010-06-23 18:34:14 |
Message-ID: | 25795.1277318054@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Excerpts from Senthil Kumar G's message of mi jun 23 07:59:26 -0400 2010:
>> I executed follows. I am able to ping.
>> ping 127.0.0.1
> So can you ping localhost?
I'm betting the problem is kernel-level filter rules that let through
ping packets but not the stats collector traffic. The reason that the
stats collector goes to such length to test the connection is that stuff
like this isn't uncommon :-(. You need to look at your firewall packet
filtering settings and back off the restrictions on localhost UDP
traffic.
regards, tom lane
From: | rafael(at)santosgrupo(dot)com |
---|---|
To: | "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, pgsql-admin-owner(at)postgresql(dot)org, "Senthil Kumar G" <senthil(at)zoniac(dot)com> |
Cc: | "sivakumar krishnamurthy" <sivakumar(dot)mailinglist(at)gmail(dot)com>, "Kevin Grittner" <kevin(dot)grittner(at)wicourts(dot)gov>, "pgsql-admin" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Unable to start Statistics Collector |
Date: | 2010-06-24 06:13:41 |
Message-ID: | 836944768-1277360021-cardhu_decombobulator_blackberry.rim.net-1889783036-@bda165.bisx.produk.on.blackberry |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
Rrtrtt
BlackBerry de movistar, allí donde estés está tu oficin@
-----Original Message-----
From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Sender: pgsql-admin-owner(at)postgresql(dot)org
Date: Wed, 23 Jun 2010 13:11:44
To: Senthil Kumar G<senthil(at)zoniac(dot)com>
Cc: sivakumar krishnamurthy<sivakumar(dot)mailinglist(at)gmail(dot)com>; Kevin Grittner<kevin(dot)grittner(at)wicourts(dot)gov>; pgsql-admin<pgsql-admin(at)postgresql(dot)org>
Subject: Re: [ADMIN] Unable to start Statistics Collector
Excerpts from Senthil Kumar G's message of mié jun 23 07:59:26 -0400 2010:
> Hi
>
>
>
> I executed follows. I am able to ping.
>
> >ping 127.0.0.1
So can you ping localhost?
--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
From: | rafael(at)santosgrupo(dot)com |
---|---|
To: | "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, pgsql-admin-owner(at)postgresql(dot)org, "Senthil Kumar G" <senthil(at)zoniac(dot)com> |
Cc: | "sivakumar krishnamurthy" <sivakumar(dot)mailinglist(at)gmail(dot)com>, "Kevin Grittner" <kevin(dot)grittner(at)wicourts(dot)gov>, "pgsql-admin" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Unable to start Statistics Collector |
Date: | 2010-06-24 06:13:48 |
Message-ID: | 2038097557-1277360028-cardhu_decombobulator_blackberry.rim.net-1358290993-@bda165.bisx.produk.on.blackberry |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
Rtt
BlackBerry de movistar, allí donde estés está tu oficin@
-----Original Message-----
From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Sender: pgsql-admin-owner(at)postgresql(dot)org
Date: Wed, 23 Jun 2010 13:11:44
To: Senthil Kumar G<senthil(at)zoniac(dot)com>
Cc: sivakumar krishnamurthy<sivakumar(dot)mailinglist(at)gmail(dot)com>; Kevin Grittner<kevin(dot)grittner(at)wicourts(dot)gov>; pgsql-admin<pgsql-admin(at)postgresql(dot)org>
Subject: Re: [ADMIN] Unable to start Statistics Collector
Excerpts from Senthil Kumar G's message of mié jun 23 07:59:26 -0400 2010:
> Hi
>
>
>
> I executed follows. I am able to ping.
>
> >ping 127.0.0.1
So can you ping localhost?
--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
From: | "Senthil Kumar G" <senthil(at)zoniac(dot)com> |
---|---|
To: | <rafael(at)santosgrupo(dot)com>, "'Alvaro Herrera'" <alvherre(at)commandprompt(dot)com>, <pgsql-admin-owner(at)postgresql(dot)org> |
Cc: | "'sivakumar krishnamurthy'" <sivakumar(dot)mailinglist(at)gmail(dot)com>, "'Kevin Grittner'" <kevin(dot)grittner(at)wicourts(dot)gov>, "'pgsql-admin'" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Unable to start Statistics Collector |
Date: | 2010-06-24 06:43:52 |
Message-ID: | 098001cb1368$a02dbe30$1201a8c0@senthilg |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
Hi
I am able to ping localhost also.
ping localhost
PING localhost (127.0.0.1) 56(84) bytes of data.
64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.037 ms
64 bytes from localhost (127.0.0.1): icmp_seq=2 ttl=64 time=0.026 ms
64 bytes from localhost (127.0.0.1): icmp_seq=3 ttl=64 time=0.050 ms
64 bytes from localhost (127.0.0.1): icmp_seq=4 ttl=64 time=0.030 ms
64 bytes from localhost (127.0.0.1): icmp_seq=5 ttl=64 time=0.051 ms
Let me also check any firewall issue?
Regards
Senthil
-----Original Message-----
From: rafael(at)santosgrupo(dot)com [mailto:rafael(at)santosgrupo(dot)com]
Sent: Thursday, June 24, 2010 11:44 AM
To: Alvaro Herrera; pgsql-admin-owner(at)postgresql(dot)org; Senthil Kumar G
Cc: sivakumar krishnamurthy; Kevin Grittner; pgsql-admin
Subject: Re: [ADMIN] Unable to start Statistics Collector
Rtt
BlackBerry de movistar, allí donde estés está tu oficin@
-----Original Message-----
From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Sender: pgsql-admin-owner(at)postgresql(dot)org
Date: Wed, 23 Jun 2010 13:11:44
To: Senthil Kumar G<senthil(at)zoniac(dot)com>
Cc: sivakumar krishnamurthy<sivakumar(dot)mailinglist(at)gmail(dot)com>; Kevin
Grittner<kevin(dot)grittner(at)wicourts(dot)gov>;
pgsql-admin<pgsql-admin(at)postgresql(dot)org>
Subject: Re: [ADMIN] Unable to start Statistics Collector
Excerpts from Senthil Kumar G's message of mié jun 23 07:59:26 -0400 2010:
> Hi
>
>
>
> I executed follows. I am able to ping.
>
> >ping 127.0.0.1
So can you ping localhost?
--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support