On Wed, Apr 27, 2022 at 7:09 AM Nikhil Shetty <nikhil.dba04@xxxxxxxxx> wrote:
Hi,We are getting below WARNING on one of the standby instances. Not sure what caused it but to resolve it we tried restarting the database instances but it is still not working
WARNING - using stale statistics instead of current ones because stats collector is not responding
Postgresql version - 11.7
Any other option to resolve this?
If it is always present (not just when IO is overwhelmed) maybe it has an internal firewall blocking UDP on 127.0.0.1.
Cheers,
Jeff