Re: pgAdmin connects 100s of times

From: mark bradley <markbradyju(at)outlook(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-generallists(dot)postgresql(dot)org <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: pgAdmin connects 100s of times
Date: 2026-01-25 22:08:58
Message-ID: CH2PR22MB2008B58B4010078ADA5552D2BA92A@CH2PR22MB2008.namprd22.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

I think I have found the problem. PgAdmin will save open tabs from one session to the other. These seem to accumulate and each one opens a connection. After a while, there are so many that pgAdmin can't even open.

Thanks.

Best regards,
Mark Brady
amazon.com/author/markjbrady<https://amazon.com/author/markjbrady>
________________________________
From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Sent: Wednesday, January 21, 2026 8:39 PM
To: mark bradley <markbradyju(at)outlook(dot)com>; pgsql-generallists.postgresql.org <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: pgAdmin connects 100s of times

On 1/21/26 17:17, mark bradley wrote:
> When I start up pgAdmin it connects 100s of times. Have others seen
> this, and what is the fix? Many messages in these green bars pop up
> and then go away. See screenshot below:
>

1) There is a dedicated pgAdmin list:

https://www.postgresql.org/list/pgadmin-support/

2) Have you looked at the Postgres log to see what the queries are
actually doing? You may need to crank up the statement logging if they
are mostly SELECTs.

3) What version of pgAdmin?

4) Do you have jobs set up with pgAgent?

6) How many servers do you have set up and do they have queries in Post
Connection SQL tab?

>
> Best regards,
> Mark Brady
> _amazon.com/author/markjbrady <https://amazon.com/author/markjbrady>_

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message felix.quintgz 2026-01-26 16:01:03 About backups
Previous Message Adrian Klaver 2026-01-23 23:11:19 Re: Resource Usage same In spite of fronting my DB server with Pgbouncer ?