Re: high cpu usage with postgres on windows XP

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(at)yahoo(dot)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(at)tishler(dot)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