Fail to connect to postgres due to invalid password

[annguyen]

I tried to connect to Postgres to run alembic migration on production environment via SQL proxy, but always failed because of error: 'asyncpg.exceptions.InvalidPasswordError: password authentication failed for user "***" though I already re-created username and password. The same code worked for DEV and QA environment with the same settings so I don't know what might have caused this. Can someone please help?

[ronnelg · Accepted solution]

Hi @annguyen, 

Welcome to Google Cloud Community!

I understand that you are getting an error asyncpg.exceptions.InvalidPasswordError: password authentication failed for user "***"when trying to connect to Postgres. May I know if you are using a docker? And can you please provide your build code for it to check? In the meantime, you can check this Stack Overflow post for some insight that may help you with the issue. 

I hope the above information is helpful.

[ronnelg · Accepted solution]

Hi @annguyen, 

Welcome to Google Cloud Community!

I understand that you are getting an error asyncpg.exceptions.InvalidPasswordError: password authentication failed for user "***"when trying to connect to Postgres. May I know if you are using a docker? And can you please provide your build code for it to check? In the meantime, you can check this Stack Overflow post for some insight that may help you with the issue. 

I hope the above information is helpful.

[annguyen · Accepted solution]

Thanks, I already figured out the issue, it was due to missing environment variable configuration.