PostgreSQL statistics collector not starting

Hi,
I'm using PostgreSQL 8.2.

PostgreSQL statistics collector is not starting as expected.  I see the following in the serverlog.

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

What is going wrong?  I couldn't understand from the above lines.

RUNTIME STATISTICS parameter set in postgresql.conf are:
stats_start_collector = on
stats_block_level = on
stats_row_level = on
#stats_reset_on_server_start = off

Does stats collector process need any other special resource/privilege/operations/port to start?

Only statistics collector process is not running, but am able to login to the database using psql.


LVL 1
ZoniacAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

James MurrellProduct SpecialistCommented:
Is an OS firewall or anti-virus program running on this machine?
Any other unusual security features
0
ZoniacAuthor Commented:
Hi cs97jjm3,

No unusual security features and no anti-virus programs are running.

But again if postgresql service can start without any issues, why not stats collector process the same way?

Does stats collector process need any other special resource/privilege/operations/port to start?   Can you let me know in this aspect, so that it would be helpful for me to  troubleshoot in better way.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PostgreSQL

From novice to tech pro — start learning today.