Unable to start Statistics Collector

This is a multi-part message in MIME format.

------=_NextPart_000_0115_01CB124A.4052F710
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0116_01CB124A.4052F710"


------=_NextPart_001_0116_01CB124A.4052F710
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

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


------=_NextPart_001_0116_01CB124A.4052F710
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" =
xmlns=3D"http://www.w3.org/TR/REC-html40"
xmlns:ns5=3D"http://schemas.microsoft.com/office/2004/12/omm l">


charset=3Dus-ascii">

Re: Unable to start Statistics Collector

"Senthil Kumar G" 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

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Unable to start Statistics Collector

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.Grittner@wicourts.gov]
Sent: Tuesday, June 22, 2010 10:43 PM
To: pgsql-admin@postgresql.org; senthil@zoniac.com
Subject: Re: [ADMIN] Unable to start Statistics Collector

"Senthil Kumar G" 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


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Unable to start Statistics Collector

--001636310789e0fc790489b01625
Content-Type: text/plain; charset=ISO-8859-1

>
> 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

--001636310789e0fc790489b01625
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Re: Unable to start Statistics Collector

This is a multi-part message in MIME format.

------=_NextPart_000_0180_01CB12F9.A2C53160
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

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.mailinglist@gmail.com]
Sent: Wednesday, June 23, 2010 4:04 PM
To: senthil@zoniac.com
Cc: Kevin Grittner; pgsql-admin@postgresql.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


------=_NextPart_000_0180_01CB12F9.A2C53160
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Dus-ascii">

namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" =
name=3D"place"/>
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"PersonName"/>

Re: Unable to start Statistics Collector

"Senthil Kumar G" wrote:
> sivakumar krishnamurthy 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

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Unable to start Statistics Collector

Excerpts from Senthil Kumar G's message of mié jun 23 07:59:26 -0400=
2010:
> Hi=20
>=20
> =20
>=20
> I executed follows. I am able to ping.
>=20
> >ping 127.0.0.1

So can you ping localhost?


--=20
Álvaro Herrera
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Unable to start Statistics Collector

Alvaro Herrera 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

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Unable to start Statistics Collector

UnJ0cnR0DQpCbGFja0JlcnJ5IGRlIG1vdmlzdGFyLCBhbGzDrSBkb25kZSBl
c3TDqXMgZXN0w6EgdHUgb2ZpY2luQA0KDQotLS0tLU9yaWdpbmFsIE1lc3Nh
Z2UtLS0tLQ0KRnJvbTogQWx2YXJvIEhlcnJlcmEgPGFsdmhlcnJlQGNvbW1h
bmRwcm9tcHQuY29tPg0KU2VuZGVyOiBwZ3NxbC1hZG1pbi1vd25lckBwb3N0
Z3Jlc3FsLm9yZw0KRGF0ZTogV2VkLCAyMyBKdW4gMjAxMCAxMzoxMTo0NCAN
ClRvOiBTZW50aGlsIEt1bWFyIEc8c2VudGhpbEB6b25pYWMuY29tPg0KQ2M6
IHNpdmFrdW1hciBrcmlzaG5hbXVydGh5PHNpdmFrdW1hci5tYWlsaW5nbGlz
dEBnbWFpbC5jb20+OyBLZXZpbiBHcml0dG5lcjxrZXZpbi5ncml0dG5lckB3
aWNvdXJ0cy5nb3Y+OyBwZ3NxbC1hZG1pbjxwZ3NxbC1hZG1pbkBwb3N0Z3Jl
c3FsLm9yZz4NClN1YmplY3Q6IFJlOiBbQURNSU5dIFVuYWJsZSB0byBzdGFy
dCBTdGF0aXN0aWNzIENvbGxlY3Rvcg0KDQpFeGNlcnB0cyBmcm9tIFNlbnRo
aWwgS3VtYXIgRydzIG1lc3NhZ2Ugb2YgbWnDqSBqdW4gMjMgMDc6NTk6MjYg
LTA0MDAgMjAxMDoNCj4gSGkgDQo+IA0KPiAgDQo+IA0KPiBJIGV4ZWN1dGVk
IGZvbGxvd3MuIEkgYW0gYWJsZSB0byBwaW5nLg0KPiANCj4gPnBpbmcgMTI3
LjAuMC4xDQoNClNvIGNhbiB5b3UgcGluZyBsb2NhbGhvc3Q/DQoNCg0KLS0g
DQrDgWx2YXJvIEhlcnJlcmEgPGFsdmhlcnJlQGNvbW1hbmRwcm9tcHQuY29t
Pg0KVGhlIFBvc3RncmVTUUwgQ29tcGFueSAtIENvbW1hbmQgUHJvbXB0LCBJ
bmMuDQpQb3N0Z3JlU1FMIFJlcGxpY2F0aW9uLCBDb25zdWx0aW5nLCBDdXN0
b20gRGV2ZWxvcG1lbnQsIDI0eDcgc3VwcG9ydA0KDQotLSANClNlbnQgdmlh
IHBnc3FsLWFkbWluIG1haWxpbmcgbGlzdCAocGdzcWwtYWRtaW5AcG9zdGdy
ZXNxbC5vcmcpDQpUbyBtYWtlIGNoYW5nZXMgdG8geW91ciBzdWJzY3JpcHRp
b246DQpodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVmL3Bnc3Fs
LWFkbWluDQoKLS0gClNlbnQgdmlhIHBnc3FsLWFkbWluIG1haWxpbmcgbGlz
dCAocGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmcpClRvIG1ha2UgY2hhbmdl
cyB0byB5b3VyIHN1YnNjcmlwdGlvbjoKaHR0cDovL3d3dy5wb3N0Z3Jlc3Fs
Lm9yZy9tYWlscHJlZi9wZ3NxbC1hZG1pbgo=

Re: Unable to start Statistics Collector

UnR0DQpCbGFja0JlcnJ5IGRlIG1vdmlzdGFyLCBhbGzDrSBkb25kZSBlc3TD
qXMgZXN0w6EgdHUgb2ZpY2luQA0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2Ut
LS0tLQ0KRnJvbTogQWx2YXJvIEhlcnJlcmEgPGFsdmhlcnJlQGNvbW1hbmRw
cm9tcHQuY29tPg0KU2VuZGVyOiBwZ3NxbC1hZG1pbi1vd25lckBwb3N0Z3Jl
c3FsLm9yZw0KRGF0ZTogV2VkLCAyMyBKdW4gMjAxMCAxMzoxMTo0NCANClRv
OiBTZW50aGlsIEt1bWFyIEc8c2VudGhpbEB6b25pYWMuY29tPg0KQ2M6IHNp
dmFrdW1hciBrcmlzaG5hbXVydGh5PHNpdmFrdW1hci5tYWlsaW5nbGlzdEBn
bWFpbC5jb20+OyBLZXZpbiBHcml0dG5lcjxrZXZpbi5ncml0dG5lckB3aWNv
dXJ0cy5nb3Y+OyBwZ3NxbC1hZG1pbjxwZ3NxbC1hZG1pbkBwb3N0Z3Jlc3Fs
Lm9yZz4NClN1YmplY3Q6IFJlOiBbQURNSU5dIFVuYWJsZSB0byBzdGFydCBT
dGF0aXN0aWNzIENvbGxlY3Rvcg0KDQpFeGNlcnB0cyBmcm9tIFNlbnRoaWwg
S3VtYXIgRydzIG1lc3NhZ2Ugb2YgbWnDqSBqdW4gMjMgMDc6NTk6MjYgLTA0
MDAgMjAxMDoNCj4gSGkgDQo+IA0KPiAgDQo+IA0KPiBJIGV4ZWN1dGVkIGZv
bGxvd3MuIEkgYW0gYWJsZSB0byBwaW5nLg0KPiANCj4gPnBpbmcgMTI3LjAu
MC4xDQoNClNvIGNhbiB5b3UgcGluZyBsb2NhbGhvc3Q/DQoNCg0KLS0gDQrD
gWx2YXJvIEhlcnJlcmEgPGFsdmhlcnJlQGNvbW1hbmRwcm9tcHQuY29tPg0K
VGhlIFBvc3RncmVTUUwgQ29tcGFueSAtIENvbW1hbmQgUHJvbXB0LCBJbmMu
DQpQb3N0Z3JlU1FMIFJlcGxpY2F0aW9uLCBDb25zdWx0aW5nLCBDdXN0b20g
RGV2ZWxvcG1lbnQsIDI0eDcgc3VwcG9ydA0KDQotLSANClNlbnQgdmlhIHBn
c3FsLWFkbWluIG1haWxpbmcgbGlzdCAocGdzcWwtYWRtaW5AcG9zdGdyZXNx
bC5vcmcpDQpUbyBtYWtlIGNoYW5nZXMgdG8geW91ciBzdWJzY3JpcHRpb246
DQpodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVmL3Bnc3FsLWFk
bWluDQoKLS0gClNlbnQgdmlhIHBnc3FsLWFkbWluIG1haWxpbmcgbGlzdCAo
cGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmcpClRvIG1ha2UgY2hhbmdlcyB0
byB5b3VyIHN1YnNjcmlwdGlvbjoKaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9y
Zy9tYWlscHJlZi9wZ3NxbC1hZG1pbgo=

Re: Unable to start Statistics Collector

Hi=20

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=3D1 ttl=3D64 time=3D0.037 ms
64 bytes from localhost (127.0.0.1): icmp_seq=3D2 ttl=3D64 time=3D0.026 ms
64 bytes from localhost (127.0.0.1): icmp_seq=3D3 ttl=3D64 time=3D0.050 ms
64 bytes from localhost (127.0.0.1): icmp_seq=3D4 ttl=3D64 time=3D0.030 ms
64 bytes from localhost (127.0.0.1): icmp_seq=3D5 ttl=3D64 time=3D0.051 ms

Let me also check any firewall issue?

Regards
Senthil

-----Original Message-----
From: rafael@santosgrupo.com [mailto:rafael@santosgrupo.com]=20
Sent: Thursday, June 24, 2010 11:44 AM
To: Alvaro Herrera; pgsql-admin-owner@postgresql.org; Senthil Kumar G
Cc: sivakumar krishnamurthy; Kevin Grittner; pgsql-admin
Subject: Re: [ADMIN] Unable to start Statistics Collector

Rtt
BlackBerry de movistar, all=ED donde est=E9s est=E1 tu oficin@

-----Original Message-----
From: Alvaro Herrera
Sender: pgsql-admin-owner@postgresql.org
Date: Wed, 23 Jun 2010 13:11:44=20
To: Senthil Kumar G
Cc: sivakumar krishnamurthy; Kevin
Grittner;
pgsql-admin
Subject: Re: [ADMIN] Unable to start Statistics Collector

Excerpts from Senthil Kumar G's message of mi=E9 jun 23 07:59:26 -0400 2010:
> Hi=20
>=20
>
>=20
> I executed follows. I am able to ping.
>=20
> >ping 127.0.0.1

So can you ping localhost?


--=20
=C1lvaro Herrera
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin