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 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
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Jason Tishler 8 September 2003 23:10:44 [ permanent link ]
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?
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Jason Tishler 9 September 2003 14:12:01 [ permanent link ]
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...
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly
If you would like to report an abuse of our service, such as a spam message, please . Если Вы хотите пожаловаться на содержимое этой страницы, пожалуйста .
