PGSTAT Error from Postmaster
Hi. I have been posting messages on the cygwin list about trouble running
the postmaster I will not re post it here but simply would like to ask if
anyone knows what, even on a traditional unix platform, the log file
message from the postmaster daemon process
PGSTAT: connect(2): Connection refused
means please? As soon as the postmaster process starts it writes this to
the log file and the process immediately exits.
It may help me track down a Cygwin Win2000 installation problem I am having.
Thanks in advance for any help you can provide.
Tim.
"Tim Finch, FosterFinch Ltd" <tim@fosterfinch.co.uk> writes:
Hi. I have been posting messages on the cygwin list about trouble running
the postmaster I will not re post it here but simply would like to ask if
anyone knows what, even on a traditional unix platform, the log file
message from the postmaster daemon process
PGSTAT: connect(2): Connection refused
means please?
It means there's something pretty broken about your networking setup :-(
The stats collection code tries to set up a UDP socket connected to
itself as a means of forwarding statistics from individual backend
processes to the stats collector subprocess. AFAICS there is no
good reason that a connection attempt to an existing UDP socket on
127.0.0.1 should ever fail, but evidently you've managed to configure
your system so that it does. (Overly aggressive packet filtering,
perhaps? Or is this just another cygwin/Windows bug?)
If you can't figure out how to get the connection to work, you can
turn off the "start statistics collector" postgresql.conf option to
bypass the problem.
regards, tom lane
Thanks Tom for your help. Zonealarm was the culprit and yes it was being
over zealous with internal routing! So, fortunately, not another
cygwin/windows bug, for once.
Tim.
At 12:23 07/03/2002 -0500, Tom Lane wrote:
Show quoted text
"Tim Finch, FosterFinch Ltd" <tim@fosterfinch.co.uk> writes:
Hi. I have been posting messages on the cygwin list about trouble running
the postmaster I will not re post it here but simply would like to ask if
anyone knows what, even on a traditional unix platform, the log file
message from the postmaster daemon process
PGSTAT: connect(2): Connection refused
means please?It means there's something pretty broken about your networking setup :-(
The stats collection code tries to set up a UDP socket connected to
itself as a means of forwarding statistics from individual backend
processes to the stats collector subprocess. AFAICS there is no
good reason that a connection attempt to an existing UDP socket on
127.0.0.1 should ever fail, but evidently you've managed to configure
your system so that it does. (Overly aggressive packet filtering,
perhaps? Or is this just another cygwin/Windows bug?)If you can't figure out how to get the connection to work, you can
turn off the "start statistics collector" postgresql.conf option to
bypass the problem.regards, tom lane