Thread: high cpu usage with postgres on windows XP
Hello, I've been trying to install postgres on XP for a couple days without much luck. I can get postgres to run, but it is using 95-97% just running on it's own. As soon as I start postmaster, the cpu usage jumps all the way up and stays there. I followed all the install instructions at: http://www.tishler.net/jason/software/postgresql/postgresql-7.3.4.README I made sure to include the additional packages in cygwin listed. I also modified the permissions of the /usr/bin, /tmp, and /var/log permissions as mentioned. I added the cygwin/bin to my path as well. 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? thanks, am __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com
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
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
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
On Mon, Sep 08, 2003 at 04:41:40PM -0700, a m wrote: > 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. Now it would be nice if someone figures out why some environments require this workaround... > thanks! You are quite welcome. 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