Cannot reconnect after password change

public inbox for [email protected]  
help / color / mirror / Atom feed

From: Thomas, Carl (KYTC) <[email protected]>
To: [email protected] <[email protected]>
Subject: Cannot reconnect after password change
Date: Mon, 19 May 2025 18:39:37 +0000
Message-ID: <SA9PR09MB4861A6F2238E3024641AFE73869CA@SA9PR09MB4861.namprd09.prod.outlook.com> (raw)

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 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 supply 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 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 does 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 password 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 reopening it; but then I lose all my tabs.  Isn't there a way to reauthenticate with PostgreSQL server from PG Admin after a password change without exiting the app completely and relaunching it?

Thanks,

Carl T.

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Cannot reconnect after password change
  In-Reply-To: <SA9PR09MB4861A6F2238E3024641AFE73869CA@SA9PR09MB4861.namprd09.prod.outlook.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox