Re: PGSTAT : COnnection Refused Error (pgsql 7.2-2 on

Jason, as ever thanks for the reply. Our postings have crossed in the post
- as I have solved the problem, see other post re: Zone Alarm, (Grrrr)
Tim.

At 10:28 05/03/2002 -0500, Jason Tishler wrote:
>Tim,
>
>On Tue, Mar 05, 2002 at 02:48:02PM +0000, Tim Finch, FosterFinch Ltd wrote:
> > At 07:50 04/03/2002 -0500, you wrote:
> > >3. Try to strace the problem:
> >
> > I did your 'unlink and copy' procedure then
> >
> > strace --output=strace.output postmaster -i -D /usr/share/postgresql/data
> >
> > (not even in background, and all output to stdout)
> >
> > err. it RAN! I managed to get pgAdmin to connect to it, and even got psql
> > working (which you may recall was a previous thread issue with it
> > crashing).
>
>Unfortunately, using strace can "fix" problems -- especially timing
>related ones.  This is due to the fact that strace-ing slows down the
>traced process.
>
> > Great! So how do you stop strace?? I ended up killing it from
> > another bash screen.
>
>Just killing it fine.
>
> > >Any thing obvious in postmaster.log?
> >
> > Well here it (below) is at '-d 4', but without strace.output (when I did
> > the strace on postmaster it worked so no error messages in log)
> >
> > [snip]
> >
> > PGSTAT: connect(2): Connection refused
> > DEBUG:  proc_exit(1)
> > DEBUG:  shmem_exit(1)
> > DEBUG:  exit(1)
>
>I grep-ed the code as follows:
>
>     $ find . -name '*.[ch]' | xargs fgrep 'PGSTAT: connect'
>     ./src/backend/postmaster/pgstat.c:              perror("PGSTAT:
> connect(2)");
>
>Hence, postmaster is crapping out at the "if" below:
>
>/* ----------
>  * pgstat_init() -
>  *
>  *  Called from postmaster at startup. Create the resources required
>  *  by the statistics collector process.
>  * ----------
>  */
>int
>pgstat_init(void)
>{
>..
>     /*
>      * Connect the socket to its own address.  This saves a few cycles
>      * by not having to respecify the target address on every send. This
>      * also provides a kernel-level check that only packets from this same
>      * address will be received.
>      */
>     if (connect(pgStatSock, (struct sockaddr *) & pgStatAddr, alen) < 0)
>     {
>         perror("PGSTAT: connect(2)");
>         close(pgStatSock);
>         pgStatSock = -1;
>         return -1;
>     }
>..
>}
>
>Are you configuring postmaster to collect stats?
>
>Sorry, but I cannot reproduce your problem so I cannot debug it further.
>
>Jason

Tim Finch,
FosterFinch Ltd
http://www.fosterfinch.co.uk