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.
