Re: DBeaver Experiencing timeouts while connecting to New Linux PostgreSql server

On 5/27/26 22:27, Srinivas Kumar wrote:
> Hello,
>
> My company has a new Linux production server of Postgresql 18. While
> connecting to it in DBeaver, users are experiencing timeouts with broken
> pipe
> errors in logs. It connects randomly, 1 in every 3-4 attempts. Since this is
> new servers in high available fashion with another standby server, there is
> very little traffic and max connections are set to 300. How do we find
> RCA for
> this? Let me know if any additional details are required. I have checked all
> security information and telnet, and it works just fine in CMD or a
> terminal.
>
> Looking forward to hearing from you.
>

There not much information, so it's hard to give you good advice. We
don't even know how the users connect - is it directly or through a
pool/proxy of some sorts, or what? What logs have messages about broken
pipes - is that the Postgres server log or some other log?

You'll have to do the usual thing people do during RCA analysis, i.e. go
step by step over all the components on the connection (between the
client and the server), figure out where exactly it fails and why.

My guess is something is dropping the connection for whatever reason
(might be a proxy, might be a VPN, ... who knows?).

regards

--
Tomas Vondra