Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vk8I9-00AE4W-0t for pgsql-general@arkaria.postgresql.org; Sun, 25 Jan 2026 22:09:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vk8I6-005ccR-2E for pgsql-general@arkaria.postgresql.org; Sun, 25 Jan 2026 22:09:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vk8I6-005ccH-0Y for pgsql-general@lists.postgresql.org; Sun, 25 Jan 2026 22:09:06 +0000 Received: from mail-eastusazolkn190110000.outbound.protection.outlook.com ([2a01:111:f403:d100::] helo=BL2PR02CU003.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vk8I3-002Hqn-0i for pgsql-general@lists.postgresql.org; Sun, 25 Jan 2026 22:09:05 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=cMRQ5JZshFdqJ3T80DzyDR0iaS0TZJVXVDOY6JKwRjkPP9b+y7isHHbmGvPbkJzPeFxTSCKxzZe6+28yok8JeJ89XWlN5k4cHzoE8pfvVhwWE7ID4vuDql3pbKxuRDwEmSJJThav06JqacUTeO4Eai+rUMaP3HklgXAhmjDxxy9NeNN6hyY0+/HLYqXYSD91VqUJaTON3vCU7FErdyXexw88YclNalqC7UiZGaBm83fDDYiAwobouov38ciKnQFU0VsURfbqXT6wgbdqfXxZr+fW1WEfWLFBi/1+phe61p+RejaYjjBXssgZynsGTPYy/OJDW0hV6dhdUDCn/cQMaA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=Utc6NgLYJxqkGE7NRlVuZcW3ICFR36dVbDP901DLJ4o=; b=vpLsGSg7t/6hojQ0vWquI2+MrPVgtdff4hGkguWL7yhDc7IPS1lIh9u6WLnH45vJPwEOsd0RGNmaISL4sHkq29DAbstyeSrFz93Oqkcamhfg1z2A+NqWx7ad7A5Gd/HcYvBrE9HGeRw8sOe+EF3gUMyjvjQ+uLTQPkA00NIGOhE9HPdXHPFoa+XFD7KNVHTsITvuwQsO9wjeHAILA13vCiP5Fm+dmt7V76vMkZcc7ww3X1tz8o3l+6o8yWwfzmUFMuCC3hdPXGINkAni3z85k9sF40oj55ICL4I6lHbzqDViZSSvfrhLZNVLlMaJm7e2SXAFdldaOhbhZFCM2TMCCQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outlook.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=Utc6NgLYJxqkGE7NRlVuZcW3ICFR36dVbDP901DLJ4o=; b=qRMnBTga9L1FBahA+mccOEwRDVb+5i+3JAJlcsHuP3b2dLlmaIObF2zUtlfuYKZbYVnZzrb7vv3VtEvYROHenDUB64G06zwgKLeFsJTf80SMxnwuCImxcARyYqC0+ofWHwBM0wBv7doSaMfBJGYYHLTHa9u/0d5MOZPlXaAx5QglBbLF77dEakLyiT95ewu1rsboZn+4G5yOWUG5uS84DlgwYvABzkPM6hZ78+3BfUJOwgZKLA9UKRyCuZZ7TdNWW4j/ClUu1ZNktMVxXVDyl+Fb68mWpXDAHnkxEkKPZ0xVe4j4SBJ9ZWz4kW+i9qDCx+coEjo0MDQnnmp6ZZ4kpA== Received: from CH2PR22MB2008.namprd22.prod.outlook.com (2603:10b6:610:89::15) by BL1PPF705B43D12.namprd22.prod.outlook.com (2603:10b6:20f:fc04::f30) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9542.15; Sun, 25 Jan 2026 22:09:00 +0000 Received: from CH2PR22MB2008.namprd22.prod.outlook.com ([fe80::bcbe:56e7:b882:7938]) by CH2PR22MB2008.namprd22.prod.outlook.com ([fe80::bcbe:56e7:b882:7938%7]) with mapi id 15.20.9542.010; Sun, 25 Jan 2026 22:08:58 +0000 From: mark bradley To: Adrian Klaver , pgsql-generallists.postgresql.org Subject: Re: pgAdmin connects 100s of times Thread-Topic: pgAdmin connects 100s of times Thread-Index: AQHcizyKUgeLQTGYR0eyqadP8di+mLVdaYKAgAYNk9U= Date: Sun, 25 Jan 2026 22:08:58 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-publictraffictype: Email x-ms-traffictypediagnostic: CH2PR22MB2008:EE_|BL1PPF705B43D12:EE_ x-ms-office365-filtering-correlation-id: 546f5ea7-2f8c-48a5-d3fc-08de5c5e56f2 x-microsoft-antispam: BCL:0;ARA:14566002|51005399006|19110799012|8062599012|8060799015|9400799043|31061999003|41001999006|12050799012|461199028|12121999013|15030799006|15080799012|3412199025|4302099013|440099028|10035399007|40105399003|12091999003|102099032|1602099012; x-microsoft-antispam-message-info: =?us-ascii?Q?Rc1O7nQ1OsJbqSCH7hs0SXUtgoi0jrqi70kO6h/JB5Fu4QyMI8S2Arp+goDq?= =?us-ascii?Q?ct0vY7NcL6TIWPQfAkWB0tHO3nmcWjQpc87ypRLhCPdKOwm5FpgF+lJrPXWu?= =?us-ascii?Q?hMQDStIv/hPqmgq51VWXAFrc88nghKHn6ek9yWxzbENjPMkFoNEMSe5qqAFP?= =?us-ascii?Q?+Yi+Gi8Ax0l+SqbER8YAqEkQQwlJvCwp9NDsQbwFUMwPyXMo6yh8X7hJKJ6N?= =?us-ascii?Q?OYSrlmLFygiKBuvVDnDAuKZLn0T1H3NXstSu97CqaQJJUCdjLwWixX3iTTWn?= =?us-ascii?Q?x8+WNa8HTkUBtCiumDS6ulpEGjHjj9wzszkQH0Jy9ZVt9Hs1HpTP0kpspF6m?= =?us-ascii?Q?S7eXkEGpwSgKzb96TjFsrpWXcYWMsMgSOhtjgsNfGZr5q9GZG+z8pWilzjji?= =?us-ascii?Q?Z7uH7KQPQZXbAUh1ul0cHc1UPCdGsFq1q97CMJU/epGl6oR+ZRVWAd+WcY75?= =?us-ascii?Q?7gKKWQv1SLWxbqPA/SzqMiMwmoF7jWD0cFCLlqz4k6vyNMZILUz8ah1V4VcX?= =?us-ascii?Q?fp5O8xnSEwhgeLUzfXAS+xTAnliQ2Wflze/ExBnUYXnskiLZvGgbpAwzjRzj?= =?us-ascii?Q?J/wH0DrevLyrgIveB10FJbwVsPiJ7R6EKG6qbXLOUxYKDQ/eufYsdXN3KcqS?= =?us-ascii?Q?Z+QjH6yUj3QHdoesepstJCtqpvQvegGoRgd6tS3c80j+qP8aHs/X+ZqU9N06?= =?us-ascii?Q?J61vddOQGnSELBy6/eLy6QSBe2fK+FHCQaVjQWo5lBnr9JlsbArfL/SUnHww?= =?us-ascii?Q?Scyu0pSlyIy/BZoSlbWGAsu0sERnkl1uLABhsceN6C+6IwQPeU75kK8mSYXR?= =?us-ascii?Q?Lft3/Goc/5xAv8GpCfhtOn4L/ii0+tNo69tXTmrgSXTwK1j5NgsfrJg9oa4D?= =?us-ascii?Q?osM+tMAOKDvnLzUZ75t85YMHp1l0zwXRSOhOWQOPeSD0kWoSpXnDmx1CpFM3?= =?us-ascii?Q?P6Wxmuj9XvlDNL0Kq0hWAiV03yFz1/E1Jq4FC33JPZR9pnepPigTmRSzOg0H?= =?us-ascii?Q?QPpV6dBCSSnS3L6ugsLm3Tqn3RBAtu0KcI6FbyaoPDPdZVMUizEX1oJ3mY06?= =?us-ascii?Q?MiyZk2FareqpBR6eZ7/a+8jV2oVAdWG2PctnQfcv/HkOYfXAX09VhGn2QLCp?= =?us-ascii?Q?lyQeXO/hqZvp+ufE8y9ktec18NEriHy6NeawjblTDRTjTxqHaI9BCB3QPUT/?= =?us-ascii?Q?hFMKdti1egwIP/JKrE/m60szeUaZ7kM6z3Z9YJLU53NKXHFsVx0/LPK1jFH/?= =?us-ascii?Q?JPhRjaVDU7D8CWroap4crz+pTCfmILbJVD5GiiQphIk1IgXh6eRzddfL/2th?= =?us-ascii?Q?On8m0XJPvKLwQvZM6lp9UIo0ikB2mxym0ASBXseyFJs2xyCycp0ni3Fxd1Oc?= =?us-ascii?Q?ntnsCDZnZXsvmAr2fVTQQi450N9SGxCrI7C4k+BtIIBpSqhPzRqCYwsdm9b4?= =?us-ascii?Q?2sOLbrhJ4Ts7gMWx58zsNz2NbS6DdU8s?= x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?JBxuqNquzO35CMaI9GThPTnvtPaZfY8ECHgD8LprBB05fTMFCVczuc9v/Cct?= =?us-ascii?Q?kN3U0xRLOSzZZdiUOwJSBiw6Rh/9yxsFNJ0PS+XW3/xG/tyxq1Wp++sc79qk?= =?us-ascii?Q?g37QqaHKH2lyIVAVLXZsMjgjPOE+I13+BRmHAkGfsMOOtAOED2O640X0zY0Q?= =?us-ascii?Q?wHbfKnJCwp48eRY1ypEuaie46UHVRy8OcH7FviShMPwEDj6LuKq1aHqhykPd?= =?us-ascii?Q?uqS9QbwVt5RWfoCDTO+0Qo7T/a/Frug+1EPQnmXVxS7dQ6wUBvnvHqqR2ROM?= =?us-ascii?Q?Ha0tJrxThDAd5wiASjC/GIl8xvWFF+H/rFfSlw6vWBtVP4zogR4uZBHG6bgb?= =?us-ascii?Q?XxtbWJF56/bkcihLgv4Hg5vjs6oYhxi6kMuj2WT8/jBFk5prB2r/IIlI1Oga?= =?us-ascii?Q?9+RJi9L9DALuDaR7dpPcgqRtxeKHB5Zo/O7klOxVLHmisjLMObkEt/MTJJ6s?= =?us-ascii?Q?KKPW/IJIlYvobuzBVR4UXGACH4losimhKxlbk+nHlK7tH7YPabdWJqpJSxKm?= =?us-ascii?Q?2xkr+2Uiu7rNuqiIlYdDUfsSWgQPaHM/BzVqae9qjKBDfACbyDfmst7fpZe2?= =?us-ascii?Q?m6QrhDsweshHncTY6yvWMPAK4lRc31u4PMTmgw1Dq2qX5GWJE/MPIcB4VpIJ?= =?us-ascii?Q?xmObEcWzRMn5z0bqmC3RpnyVx2l8+2irh8lkK2+dDRDcXYov2Ml93Ad9Udez?= =?us-ascii?Q?/Z8H+mk4o8E7dIPumg6VCCNYUar6CZHNQVvExSnr5JoZeUbGDUUO0OyorGTR?= =?us-ascii?Q?pYgv+DTq2gZm3kfe12BexrTlc5EdGlhRHb0z/j6Nk3UQiblA84SHbFwoOTD1?= =?us-ascii?Q?e71dLOZzQl1XqhZfyAU30N/tNMayxPQp5I0mnO4oQzyMTv53XkLokkBw4A4O?= =?us-ascii?Q?dwKdFc9QRY4oUKIcSliACoS5xAO2nh2ua21o+6NFpfhMN3mRc7W/4XifFGD2?= =?us-ascii?Q?o3trPmPKzCvYG1paxtuyy0b7xW1oURutdpfE2PoeQC90tSgaMJpnxtYCmunn?= =?us-ascii?Q?6NsPDnKpg1hmbS0ZX4o9QsnNR8hpus21dz4xSoRJJSOqa/RLmt0+J60HLrBx?= =?us-ascii?Q?QI8UXaxvBAN6sT4G/Fk16m0nGawYbpcLzdjpBxfP5YzXYsG1nGNKWOfaPzp1?= =?us-ascii?Q?XWG4jO49ygksvCg5JZDzrMFJ8WDR7SSLCTZrp0tpKLdsbIUy0s3PkZngkgny?= =?us-ascii?Q?h8Jgnx/UIbnhyWnpUjxfPr6q9m/HJADgiWyaePPFtlmgVj4q1/d66uNlm7ND?= =?us-ascii?Q?N3scOS6pWiuTJ44W1s0blkEJO9wo0QY3xwVvOk2olrRhOWO2cx/wNaHGIWPH?= =?us-ascii?Q?f7Joa4CO+OowSm8ELSIkmPQcOCXCccrgdCyrmm0nPuufrXDT6xVMtxNa3HL5?= =?us-ascii?Q?6HvyXYVyKAlJhS7yFG2j2l4AfbEjwLALJpO8w2XQfkG/Om0kfuAbV5bXO8sx?= =?us-ascii?Q?18PaqKC4/l+De7ymEc7qd9EnMqtq5DJw?= Content-Type: multipart/alternative; boundary="_000_CH2PR22MB2008B58B4010078ADA5552D2BA92ACH2PR22MB2008namp_" MIME-Version: 1.0 X-OriginatorOrg: outlook.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: CH2PR22MB2008.namprd22.prod.outlook.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: 546f5ea7-2f8c-48a5-d3fc-08de5c5e56f2 X-MS-Exchange-CrossTenant-originalarrivaltime: 25 Jan 2026 22:08:58.7492 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: BL1PPF705B43D12 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_CH2PR22MB2008B58B4010078ADA5552D2BA92ACH2PR22MB2008namp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I think I have found the problem. PgAdmin will save open tabs from one ses= sion to the other. These seem to accumulate and each one opens a connectio= n. After a while, there are so many that pgAdmin can't even open. Thanks. Best regards, Mark Brady amazon.com/author/markjbrady ________________________________ From: Adrian Klaver Sent: Wednesday, January 21, 2026 8:39 PM To: mark bradley ; pgsql-generallists.postgresql.o= rg 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 _ -- Adrian Klaver adrian.klaver@aklaver.com --_000_CH2PR22MB2008B58B4010078ADA5552D2BA92ACH2PR22MB2008namp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
I think I have found the problem.  PgAdmin will save open tabs from on= e 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
From: Adrian Klaver <adr= ian.klaver@aklaver.com>
Sent: Wednesday, January 21, 2026 8:39 PM
To: mark bradley <markbradyju@outlook.com>; pgsql-generallists= .postgresql.org <pgsql-general@lists.postgresql.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 s= een
> 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.po= stgresql.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.klaver@aklaver.com
--_000_CH2PR22MB2008B58B4010078ADA5552D2BA92ACH2PR22MB2008namp_--