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.94.2) (envelope-from ) id 1uH5Ow-00DGo8-Uo for pgadmin-support@arkaria.postgresql.org; Mon, 19 May 2025 18:39:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uH5Ou-000Pmj-72 for pgadmin-support@arkaria.postgresql.org; Mon, 19 May 2025 18:39:48 +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.94.2) (envelope-from ) id 1uH5Ot-000Plx-GO for pgadmin-support@lists.postgresql.org; Mon, 19 May 2025 18:39:47 +0000 Received: from mx0a-00377201.pphosted.com ([148.163.135.176]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uH5Op-002cXP-0W for pgadmin-support@lists.postgresql.org; Mon, 19 May 2025 18:39:45 +0000 Received: from pps.filterd (m0168910.ppops.net [127.0.0.1]) by mx0a-00377201.pphosted.com (8.18.1.2/8.18.1.2) with ESMTP id 54JGSekM014643 for ; Mon, 19 May 2025 14:39:42 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ky.gov; h= content-type:date:from:message-id:mime-version:subject:to; s= 492024; bh=Oh2NhBMnhlKGvcYvStkrqJG3CC/02biGE+AQ6NrbzkE=; b=wMTQr q5jrQzhdPoC+dKmmSSy/AmPeQ4li7TUmWFv2fSSmTNSqSBJuWMp/LRgsRuthGasZ G6lun6lX83shCS/IaCmR4qCWFJIpB61SKDWSUUwQ20fTrlCz716GeUJ4f9hG7W40 UQiWABGZfiutKE3dufuL19BaK3U8Pg146FTGCIZkpQzEbbs514iV9aUBDs3ae1Zz K3QPZMrtclbcsljkvom0m4UZP5kt99bQ78uYH82HUfvnllITTnWLhJOdU9LBoUq6 1QepeKXhn7/vAx33cgYum/pQEUwfxlkjpvVjr89PWDO3r2uV0rNzZXvvylKf8v0p W3Ubx/A5HMYKMQTeQ== Received: from by5pr09cu001.outbound.protection.outlook.com (mail-westusazlp17011012.outbound.protection.outlook.com [40.93.1.12]) by mx0a-00377201.pphosted.com (PPS) with ESMTPS id 46q7m1jp70-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT) for ; Mon, 19 May 2025 14:39:42 -0400 (EDT) ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=FIggSW3MnNL3s3BoB6WNJ1ysZLZJyEVRs0h+UdJIAGLCj7s2zsm6NzWLbhhE+d2oEcy6EXkFrwzSLUo5AY0UuS7nJPAZUC3XllAjsikylwSZpIFgkzHgxU5b4z+KVo74lvCkSH+BlM/Q6u5xt/5htahnLRmD8CCgFYoLpI3kfoz4nUNQ9hnwrWhvY2e1OdEfXEXATyJRrU272HTp+ae+rsxf1X/DYd/k1lKkEswQrJ6VUPkzcHPMeLlntKUaVf5TQ0IgDGFg/Elt5XgrkQL/9r/OrOo6LMdsm2vI95WBzBLc4hsL+MbEjevm9rsA37jagsFjMxPSVfCl9WaEyziPcg== 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=Oh2NhBMnhlKGvcYvStkrqJG3CC/02biGE+AQ6NrbzkE=; b=FC/t2SaWKnm/VIx3+wzdrlyZSA9uXV5iaY1+pnTiUh33/9HlZsxCvvKWmqy+lp6H25UOG4fXi8WE5DXt6xxqZlWRp04lbcy7SrOm3+ReqcY98RxcUXha3W2flZIjIX0PaoSD/Hkpx9oVuYgPW0mXrvbha38ZbiGQg3X6VBWPy1/REWJhuk7PcEhlx6yeJUkB0EMTXuLUp3PpRLXQxJKq33Hy64UXBFYTSC872nnOsqTTMDz2aOTItxQLJ7jR0+InyOVvQqtZIDdo8Gf21sksww2CeOoLmn7iSu6zttxsqKpqVg+iwa/pTrf6YrSdLgnhA4fEfWu2YscR6BRqmxbmCQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=ky.gov; dmarc=pass action=none header.from=ky.gov; dkim=pass header.d=ky.gov; arc=none Received: from SA9PR09MB4861.namprd09.prod.outlook.com (2603:10b6:806:47::12) by CO6PR09MB8742.namprd09.prod.outlook.com (2603:10b6:303:c3::14) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8746.31; Mon, 19 May 2025 18:39:37 +0000 Received: from SA9PR09MB4861.namprd09.prod.outlook.com ([fe80::6f44:e8be:b3ba:5397]) by SA9PR09MB4861.namprd09.prod.outlook.com ([fe80::6f44:e8be:b3ba:5397%3]) with mapi id 15.20.8746.030; Mon, 19 May 2025 18:39:37 +0000 From: "Thomas, Carl (KYTC)" To: "pgadmin-support@lists.postgresql.org" Subject: Cannot reconnect after password change Thread-Topic: Cannot reconnect after password change Thread-Index: AdvI6h0ah6a9Wch+SNy9NOeT4ekTAA== Date: Mon, 19 May 2025 18:39:37 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-publictraffictype: Email x-ms-traffictypediagnostic: SA9PR09MB4861:EE_|CO6PR09MB8742:EE_ x-ms-office365-filtering-correlation-id: 143e2b1d-02c5-49a7-daf1-08dd9704821e 'x-ms-exchange-organization-skipsafeattachmentprocessing: 1 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|1800799024|366016|38070700018|13003099007|8096899003; x-microsoft-antispam-message-info: =?us-ascii?Q?R8bakJqrPZQFp+TD5zkIDS6xEq86ZzPQXQw1ZHmv7Q944bTHqBsLrAinVIJA?= =?us-ascii?Q?MFHr4U9Yk5jX+jZUJBta6BG1vy4jNfS261CFGI2wg7+B7BLI6VSYP71r/nkn?= =?us-ascii?Q?q+04rpjSHDLc2n7L2iE6BgQlM/DfQpN3iTY60S3NP5rsfNwUdQDU32RwKj8L?= =?us-ascii?Q?giaIhEP83+AHK+oL8o9roUGmHy0sSj4K4T8bMukYiiPWgfEZjixKGHU2Re6V?= =?us-ascii?Q?Cu8yy1Evl/USeUQmOLnz838nznN8XU3QOMjMLTYDw21N2qXoLRiNeXuHKW28?= =?us-ascii?Q?8QAC3Yc0tBbHCULvd7fYcZPGej3uy7suok5uKk4ehsswZLBool7rW/7CdeSa?= =?us-ascii?Q?W6Y5zvLNa5B3POFpE6Zo5Lh1MZdjETW8KYeUAALkq8oD14sUvf3+yuENQAXQ?= =?us-ascii?Q?Z5TxlDheD+FHBsw486/UffAQw7wqlbMsHmh8dhzp5m2snUA7gmE6fxKC7buO?= =?us-ascii?Q?xOSUp5itRyWTYfYhKPMDYJIj1j7cOTZs0/n4GI227LzluGlLh7c/6qj1z5G8?= =?us-ascii?Q?ZFoQFeXrAtEDG3DHObjNaa7UDn+1RPXYs7ZaGaOhrRUJkfUH9z4jfabk5b3i?= =?us-ascii?Q?EerhhVYoVIJWbskYjL/paNI4qVjP3IA90/Onl8MJYKSJZRyrr4PReQQAwuUW?= =?us-ascii?Q?tnmY97FbhNCIGlsgeaSxYEMvdCZBEuOSLTSa4D89GqAUWlEF1DruMQL2hGN6?= =?us-ascii?Q?C5fxQ1iU4Z6D/tRWGpqjVQuxEUpqoFne284nQoXuUtALaKFBxM/08aU1WUwY?= =?us-ascii?Q?DX+/IVb2TiUDajuh82eRjuyMC3wiHonfTALskt824D3ispEfrwFfJRRvsEzE?= =?us-ascii?Q?vNbnkbROY8ywoEYR9b+Vb3LCjLzKBlT5MW6ZpL0KMkPSAB+/mjeKO/nhbgm7?= =?us-ascii?Q?0uEbscp6nH9HxbMw+CP3+LtmrwD1I+eRWjfDTBMnevn9tlGwjb5U6ayn9Nzb?= =?us-ascii?Q?UkYkDscCVKZj42qeKIhnWQDHPxWe8hIhG1mNwWaFSgr8g/jMV0IbBAPwKxfP?= =?us-ascii?Q?1uo/2YuCAukpOsqpCiQRQu+qVX0mP4plF4AcIVF4Dnfq9OSHBn0pNgYbttzN?= =?us-ascii?Q?bK3tNk+uFsI5mQKudExgkPVMVWAvWobe0AIVKIAII2SfwNIux9B0jG3q1Hti?= =?us-ascii?Q?rqjO4AyrjbIzRndnP4xY40I1aSlKB4sSoiWuZwHUH7bp61f1Veuqot2FbFqH?= =?us-ascii?Q?Kimu+fg6fBIt0TCOmR0DU8JpXqFwQ739T3GZcXwoYegP07jZqrZXoLrKgO70?= =?us-ascii?Q?CB/IMiHc/0dr5lLZf9cdA/MOCrxF5A/NBSmEPHB5k0Xri0v1B/+XcqRQ43Gf?= =?us-ascii?Q?a14gXaETfiVzBS2auAvwzMvlNP3cSuqHSTh++ZmH/VrRvxOEqDwpSNcfqx7d?= =?us-ascii?Q?JLfyL4eM8HZrXrVatCwf0Yt1PkpkuiEmVaJ4urMjI+xyK6rItiOVwank2G6S?= =?us-ascii?Q?xB5X1Gd0T2WMEu5HXfJJNXXXdX5ygcrQyZbN4PHUpOmop4gnZm8DWQ=3D=3D?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:SA9PR09MB4861.namprd09.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(1800799024)(366016)(38070700018)(13003099007)(8096899003);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?iriU6KusoEVmAhpBzb84JeDXw7Nl3CrVOXOqZ4QTQiCdRTJ2aSfQM+d6lzKn?= =?us-ascii?Q?mOujxbTadEmfzxr+629YT+wZeD3FXmYXTOgjijAgxak6ypkYSjwG6vnJH6uA?= =?us-ascii?Q?een0spU+w2R+tC8G0DDcIf18XtE3OJo83sgd8VDEAecYn+VTYzCRYB/Bb1Pa?= =?us-ascii?Q?MhfIktCsI4h2URn0W8b1V0uRq02IwhWYKObJ+SRmGhwnAfISwLGWErzJzIf2?= =?us-ascii?Q?HpjFfvbffGOwGzzxpc4yjDaJ4R9EYbG9HbngOvaivN8U8jPQscxotRP4yDRs?= =?us-ascii?Q?Fb1ZnHicq7l9/3f67hIVJBRQQ9Ztonc6/f78Tr5RHxUE7GNy9tDtn8RxGlvJ?= =?us-ascii?Q?bwae8nm5hsNlKTGHTo2kki6lzGqahEjW4gnS+bA5r5XGABpeudFoSMI/E+Hu?= =?us-ascii?Q?T7J71Kc1K7JEedZIbzaP1e3G/upzHXAFrIjQuVkM+i7qn3ZggckY+3m41INa?= =?us-ascii?Q?GRTNIoGZnadMaqny1Ez1nDkZqkmKxZ439NfTk81jI8J6sw3swNEx9zEGIxbc?= =?us-ascii?Q?HQtFBHE2P5Eqgsg4krJ9b2laLD867a3CbnJcUwB3jotM98Px7qHL3PD6rIg0?= =?us-ascii?Q?Cy/BpvyGl9Dm9AKw1XAutloLffFd86nrqqla5YDf87LFS17fMfBITKBbMkLy?= =?us-ascii?Q?2UK+63nLJObT7kzapDd4Aos7tCM76ThMV9uW72F0c6KRPU80vY+3KXRss6tj?= =?us-ascii?Q?TFOQqwqHrSSVYHmDeANvfu+S7p5plv+sEDr98EqpIwmLONQm0k2sAN3nZhd6?= =?us-ascii?Q?kKwBHCWDy7alOT+ufR/X9PS16qcSLRQVp9ZTUMkEujvpdT/b3C53+nHmQiQX?= =?us-ascii?Q?GgBxlcVfHqw/UQTFS7ycFyXOle0GlrkQlXZTldQn0W+IKVAihuep+hRFU3cl?= =?us-ascii?Q?Rlhi+cXbBEWsXse55VpW3XK1acTnm08OhTniYSyucMpBKCJmYFAadF7dtXfO?= =?us-ascii?Q?2WryPW6F4IPFRw0yofEXf83nUyW/1gY+HF5rsXQL7IsxDFmX9It83yw+Sy/A?= =?us-ascii?Q?wZPyW0PodBGADttj9YZVIz3v6bO7bsK5Ap9lWHfWJKIUmvhcaZFl8gggqgYv?= =?us-ascii?Q?cXfJi8lJee4xnIeMygLa39RNEQCdsGictzYdiSZshUtTY7iWPYCLXaK7oADc?= =?us-ascii?Q?20mBRfmIThRJ9Lo5vV+WGgsmUqYtJGrBA7cBK5ap8WsdO9u2E8wgiZebMT8l?= =?us-ascii?Q?jIX6LaYhB4HIPOrIXC+HLHHqCC7xcDbHJm8u8StHSsTu7kTUeM3afHgxUqeF?= =?us-ascii?Q?l++TgMmfsLDtKAsQCXHhzSgkBifLRYOajMADrfSaAAM2IrF7f6LMYEZqe+Mt?= =?us-ascii?Q?qOEj7zsdaDxdihfuO4ScH8TCOuC8CgDBqijtrhfQfzsDVWWt3ajUcVf8ded6?= =?us-ascii?Q?maempiEIGe4srpUAh3lBKe7vULhxw7AQN7SaUOUv0rqVT1wexCqrrIqUa89a?= =?us-ascii?Q?Zt3820/8bC+2hkiA83qxLqdCLMmOcMk9fVS6kQUqWzEyQ92iO862HyuzhKtR?= =?us-ascii?Q?n3mPfk+Xwg+mR/PBw0CgL5cpdEZw8siFlLGjbHT4S4k0gKI/UEMZ932amupr?= =?us-ascii?Q?U2fVhZgkyzUKdsb6JpAKo2EOuCkjQ2G05Tsfqarj?= Content-Type: multipart/alternative; boundary="_000_SA9PR09MB4861A6F2238E3024641AFE73869CASA9PR09MB4861namp_" MIME-Version: 1.0 X-OriginatorOrg: ky.gov X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: SA9PR09MB4861.namprd09.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 143e2b1d-02c5-49a7-daf1-08dd9704821e X-MS-Exchange-CrossTenant-originalarrivaltime: 19 May 2025 18:39:37.4841 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: d77c7f4d-d767-461f-b625-0628792e9e2a X-MS-Exchange-Transport-CrossTenantHeadersStamped: CO6PR09MB8742 X-Proofpoint-ORIG-GUID: jnq3ts_dhh3CpvnL04TPSZCjYgzKv_wr X-Authority-Analysis: v=2.4 cv=RLizH5i+ c=1 sm=1 tr=0 ts=682b7aee cx=c_pps a=KqpwFSfdVG1OL+208k7tKw==:117 a=lCpzRmAYbLLaTzLvsPZ7Mbvzbb8=:19 a=wKuvFiaSGQ0qltdbU6+NXLB8nM8=:19 a=Ol13hO9ccFRV9qXi2t6ftBPywas=:19 a=xqWC_Br6kY4A:10 a=dt9VzEwgFbYA:10 a=jsHIX8GqAAAA:8 a=aLeDX3wtMidLSfV7RowA:9 a=CjuIK1q_8ugA:10 a=yMhMjlubAAAA:8 a=SSmOFEACAAAA:8 a=I8-6XI5aWNsP1YaQ:21 a=gKO2Hq4RSVkA:10 a=UiCQ7L4-1S4A:10 a=hTZeC7Yk6K0A:10 a=frz4AuCg-hUA:10 a=6nSNcEzV13FhKHrcAVEz:22 X-Proofpoint-Spam-Details-Enc: AW1haW4tMjUwNTE5MDE3NCBTYWx0ZWRfX731CQr9793Mz QxI5qmbqiZOfbYEWng5Fk0w/mdYGb8F6qrpTZl18SPoPPQCI9P5nDAGVXHpnnyiRDulP++nCtbk /+YhvIQUrwUdCFjtZYKRMLh89dP7Up0qD2bjAnjJIvR/X7yRbsVonk97qwaFSjKD7OTpJ6G8a7a zQA1sNweqndZPicOA3FbeHp76KgppT//2bzArUSk1Ep/2vJsSL9wHZPVx+I7gQXslQd6EMHr2Lg DWA/fUW6Yv2K9n4CGYkFC7C3BUtQh1rGaVQSAmRkETLwT9r2+OIxrO+n8dFCrT1V0S7pe5sYhdJ MjGzVZHYUxvY0pfKUI4rkS7o9PP+X1fzZ8hiCdGGA4tG6E4OLSOOlCDv9VjC3KGcnkZHB+iFFa5 BuzmvWlene7o5wy0RvEO5gPksg9KJxrh1asyvOvpaMdtEGYVaxIy1+bbuZciHiLiBZVDhcCr X-Proofpoint-GUID: jnq3ts_dhh3CpvnL04TPSZCjYgzKv_wr X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.293,Aquarius:18.0.1099,Hydra:6.0.736,FMLib:17.12.80.40 definitions=2025-05-19_07,2025-05-16_03,2025-03-28_01 X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 adultscore=0 mlxlogscore=593 malwarescore=0 bulkscore=0 mlxscore=0 lowpriorityscore=0 clxscore=1011 priorityscore=1501 impostorscore=0 phishscore=0 spamscore=0 suspectscore=0 classifier=spam authscore=0 authtc=n/a authcc= route=outbound adjust=0 reason=mlx scancount=1 engine=8.19.0-2505070000 definitions=main-2505190174 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_SA9PR09MB4861A6F2238E3024641AFE73869CASA9PR09MB4861namp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Greetings, Please indicate if this is the correct group to ask this, or which would be= more appropriate if not. I work in a government office who is switching their legacy system to FAST = (see https://www.fastenterprises.com) with PostgreSQL as the data storage p= latform. FAST connects developers to the database roughly in the following= steps: * generates a new random password * creates an SSH connection to PostgreSQL server * opens a localhost:XXXX bridge to the SSH connection In order to use PG Admin to access our PostgreSQL instance I have to point = it at the localhost URL (after the SSH connection is established) and suppl= y my user name and the random password created in the previous steps. Here's the issue. Throughout the day I often find myself having to restart the FAST software = which, in turn, generates another new password and reinitiates the SSH conn= ection causing PG Admin to disconnect. And it cannot reconnect due to inva= lid credentials. What I would expect is for PG Admin to prompt me to re-enter the new passwo= rd after a failed login. However, it does not. All it does is complain a= bout being disconnected. I have even found the context menu that allows me= to delete the saved password. Even then, it does not ask me for the new p= assword and I cannot for the life of me find where to enter the new passwor= d and thus reestablish the connection. My only option appears to be exiting PG Admin and reopening it; but then I = lose all my tabs. Isn't there a way to reauthenticate with PostgreSQL serv= er from PG Admin after a password change without exiting the app completely= and relaunching it? Thanks, Carl T. --_000_SA9PR09MB4861A6F2238E3024641AFE73869CASA9PR09MB4861namp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Greetings,

 

Please indicate if this is the correct group to ask = this, or which would be more appropriate if not.

 

I work in a government office who is switching their= legacy system to FAST (see https://www.fastenterprises.com= ) with PostgreSQL as the data storage platform.  FAST connects dev= elopers to the database roughly in the following steps:

 

  • generates a new random password
  • creates an SSH c= onnection to PostgreSQL server
  • opens a localhost:XXXX bridge to the SSH connection

 

In order to use PG Admin to access our PostgreSQL in= stance I have to point it at the localhost URL (after the SSH connection is= established) and supply my user name and the random password created in th= e previous steps.

 

Here’s the issue.

 

Throughout the day I often find myself having to res= tart the FAST software which, in turn, generates another new password and r= einitiates the SSH connection causing PG Admin to disconnect.  And it = cannot reconnect due to invalid credentials. 

 

What I would expect is for PG Admin to prompt me to = re-enter the new password after a failed login.   However, it doe= s not.  All it does is complain about being disconnected.  I have= even found the context menu that allows me to delete the saved password.  Even then, it does not ask me for the new passwo= rd and I cannot for the life of me find where to enter the new password and= thus reestablish the connection. 

 

My only option appears to be exiting PG Admin and re= opening it; but then I lose all my tabs.  Isn’t there a way to r= eauthenticate with PostgreSQL server from PG Admin after a password change = without exiting the app completely and relaunching it?

 

Thanks,

 

Carl T.

--_000_SA9PR09MB4861A6F2238E3024641AFE73869CASA9PR09MB4861namp_--