APIs cannot connect to PostGreSQL after password change

Christy H 1

I have two APIs - one Python and one .NET core - that connect to a single PostGreSQL server (Gen 5) with multiple databases. After resetting the master password, neither API can connect to either database.

The password is not hard-coded anywhere, and I can connect via PGA Admin, leading me to believe I need to update some Azure configuration settings.

Can someone assist? Thanks in advance.

Takahito Iwasa 4,841 Reputation points MVP

2022-05-06T20:33:57.403+00:00

Hi, @Christy H
Where are you deploying your API?
GeethaThatipatri-MSFT 27,012 Reputation points Microsoft Employee

2022-05-06T22:08:23.78+00:00

Hi @Christy H
Welcome to the Microsoft Q&A forum, and thanks for reaching out.
If you are connecting directly then the issue is with your API, or the password is cached somehow.

Regards
Geetha
Christy H 1 Reputation point

2022-05-07T00:01:48.183+00:00

To an Azure App Service (Linux).
Christy H 1 Reputation point

2022-05-07T00:08:48.907+00:00

I am 99% sure this is not an issue with either API, as both are experiencing the same problem with very different code under the same conditions.

Can you clarify where it might be cached? Restarting the App Services does not fix the problem.
GeethaThatipatri-MSFT 27,012 Reputation points Microsoft Employee

2022-05-10T12:02:30.42+00:00

@Christy H Are you using a private or public connection?

Regards
Geetha
GeethaThatipatri-MSFT 27,012 Reputation points Microsoft Employee

2022-05-13T17:13:55.393+00:00

@Christy H I have not heard back from you. Just wanted to check if you are still facing the issue?

Regards
Geetha