Postgresql An I/O error occurred while sending to the backend

Question

I have postgresql 9.1.19 deployed on a Windows Server 2008 R2.

For some reason, it started throwing exceptions with no other information other than "an I/O error occurred while sending to the backend".

It only happens with certain tables.

If I use a clean database, the error disappears, which leads me to believe I am running out of memory or some other allocated resource which is causing the error??

I'm connecting via JDBC.

Any insights would be greatly appreciated.

Thanks.

Scott.

Answer 1

The error means you're timing out while connecting to the database.

Check you have the connection configured correctly. If it is, see if you have access to the database or there's some firewall forbidding the access.