Re: high cpu usage with postgres on windows XP - Mailing list pgsql-cygwin

From a m
Subject Re: high cpu usage with postgres on windows XP
Date
Msg-id 20030908234140.65302.qmail@web10102.mail.yahoo.com
Whole thread Raw
In response to Re: high cpu usage with postgres on windows XP  (a m <arte91@yahoo.com>)
Responses Re: high cpu usage with postgres on windows XP
List pgsql-cygwin
ignore the last message - I fixed it.

The problem I was having is that I wasn't able to see
into the /usr/share/postgres/data folder as the
permissions were set to "postgres". I was trying to
use conf files outside that folder.

In case anyone else runs into the same problem, the
fix listed in the link below works - setting
stats_start_collector to false in the following file:
/usr/share/postgresql/data/postgresql.conf. You may
have to login/switch user to the "postgres" user to
access that folder and make the necessary change.

thanks!

--- a m <arte91@yahoo.com> wrote:
> Hi Jason,
>
> thanks - I tried that - it doesn't seem to be
> picking
> up the conf file though as it's still writing out
> the
> error messages to the postmaster.log file.
>
> I copied the "sample" conf file to
> "postgresql.conf",
> uncommented out the line and changed it to false. I
> tried the same in the .sample version. I even tried
> uncommenting out all the lines in the .conf file.
>
> Should the file be in a different directory than
> /usr/share/postgresql? or is there some option to
> get
> it to recognize the .conf file? I tried starting and
> stopping both ipc-daemon2 as well as postmaster - I
> rebooted as well.
>
> thanks
>
>
> --- Jason Tishler <jason@tishler.net> wrote:
> > am,
> >
> > On Mon, Sep 08, 2003 at 12:31:04PM -0700, a m
> wrote:
> > > The only thing I can find are the following
> errors
> > in the log file:
> > >
> > > LOG:  PGSTATBUFF: recvfrom() failed: Resource
> > > temporarily unavailable
> > > LOG:  statistics collector process (pid 3092)
> > exited
> > > with exit code 1
> > > LOG:  PGSTATBUFF: recvfrom() failed: Resource
> > > temporarily unavailable
> > > LOG:  statistics collector process (pid 3184)
> > exited
> > > with exit code 1
> > > ...
> > > These lines are repeated indefinitely until I
> shut
> > down postmaster
> > > (the only thing that changes in the messages is
> > the pid).
> > >
> > > Any ideas or suggestions?
> >
> > Does the following workaround help with your
> problem
> > too?
> >
> >
> > http://cygwin.com/ml/cygwin/2003-07/msg00722.html
> >
> > Jason
> >
> > --
> > PGP/GPG Key:
> http://www.tishler.net/jason/pubkey.asc
> > or key servers
> > Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD
> > E4CC ECF4 8EF6
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site
> design software
> http://sitebuilder.yahoo.com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

pgsql-cygwin by date:

Previous
From: Patrick Bakker
Date:
Subject: Re: Windows XP SP1, PostgreSQL 7.2.4, Cygwin 1.3.22,
Next
From: "Roger Ackroyd"
Date:
Subject: postmaster will not start with 7.3.4-2