public inbox for [email protected]
help / color / mirror / Atom feedCannot reconnect after password change
2+ messages / 2 participants
[nested] [flat]
* Cannot reconnect after password change
@ 2025-05-19 18:39 Thomas, Carl (KYTC) <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Thomas, Carl (KYTC) @ 2025-05-19 18:39 UTC (permalink / raw)
To: [email protected] <[email protected]>
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Cannot reconnect after password change
@ 2025-05-22 09:21 Anil Sahoo <[email protected]>
parent: Thomas, Carl (KYTC) <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Anil Sahoo @ 2025-05-22 09:21 UTC (permalink / raw)
To: Thomas, Carl (KYTC) <[email protected]>; +Cc: [email protected] <[email protected]>
Hi Thomas,
Have you ever entered the new credentials after the new password generation
in pgAdmin? Please share logs and screenshots.
Can you please try refreshing the server group node after which you should
see the server is disconnected and when double clicking on the server, it
will ask the password for connection.
Thanks
Anil
On Tue, May 20, 2025 at 12:09 AM Thomas, Carl (KYTC) <[email protected]>
wrote:
> 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.
>
--
*Anil Sahoo*
Software Development Engineer II
LinkedIn <https://www.linkedin.com/in/anilksahoo9/; || Blog
<https://www.enterprisedb.com/anil-sahoo; || *GitHub
<https://github.com/anilsahoo20>*
enterprisedb.com
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-05-22 09:21 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-05-19 18:39 Cannot reconnect after password change Thomas, Carl (KYTC) <[email protected]>
2025-05-22 09:21 ` Anil Sahoo <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox