Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm asking about this here because in the PostgreSQL mailing lists no one answered me. In one of my servers (Windows 2008 R2 Standard/PostgreSQL 9.0.5 64 bits) the logs are being flooded with the following message:

2012-03-26 00:00:11 BRT AVISO:  pgstat wait timeout
2012-03-26 00:00:19 BRT AVISO:  pgstat wait timeout
2012-03-26 00:00:31 BRT AVISO:  pgstat wait timeout

I checked other threads in the PostgreSQL mailing lists that were answered, but there are no definitive answer. Some speculate about I/O overload, but I don't think it would cause this message to be logged almost all the time that the server is up. Do you, that use the combination of Windows+Postgresql, have ever had this problem? If yes, were you able to fix or identify the problem?

Thanks

share|improve this question
    
I've had the problem. Rebooting the db server solved it, at least for a while. I'm in the same boat as you, trying to find an answer! –  Scott Herbert Feb 10 '13 at 22:23
add comment

1 Answer

Reloading the config makes the errors go away, and performance improves (and db statistics start getting recorded again).

I've set up a Windows Scheduled Task which performs a pg_ctl reload -D"insert here the address of your pg directory" on the hour (we're running an incredibly busy application). Hacky, but it's working.

share|improve this answer
1  
Hi Scott. The cause of this problem remains a mystery. There's [patch] (git.postgresql.org/gitweb/…) that was to be included in version 9.2 of PostgreSQL. It can help identify the problem, but I didn't had the time to test. –  Norberto Feb 14 '13 at 15:29
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.