Does anyone have a solution for the weird Azure Postgres use

Question

Does anyone have a solution for the weird Azure Postgres username format `user host` when used in a connection string If I replace it by ` 40` I have the `graphql` service complaining about an invalid interpolation If I leave it in the bit after the is parsed as the host including the password etc by `hasura` Is there any other format I can pass to ` postgres url`

Pierre Monico · Answer

PS <https stackoverflow com questions 50499495 remove the from azure postgresql username|This is the issue> I also tried by setting the variables independently in the `config toml` but that leads to the same result

Pierre Monico · Answer

Or in simpler words how do I escape an ` ` from the username in the connection string passed to ` postgres url`

Pierre Monico · Answer

I am confused because in her <https www youtube com watch v=EwsMecjSYEU|video> Laura mentions she is able to do it on Azure even though in her case it s with the helm chart rather than the docker compose approach

Kevin Kho · Answer

Looked at Laura s video and she used the default database Not really sure here but could you show the invalid interpolation error

Pierre Monico · Answer

Just realized I didn t expose the issue very clearly Azure Postgresql automatically sets the username to `user host` This leads to a weird connection string `<postgres user host> password server port dbname` Because of this most client will struggle parsing it thinking the part after the ` ` in the username is the server and that there is no password This is a know problem as the SO link above shows

Pierre Monico · Answer

When I pass it in that form to ` postgres url` I get a ` internal invalid port number ` lt password gt lt host gt <http postgres database azure com 5432 |postgres database azure com 5432 > ` gt gt it basically thinks the part after the ` ` in the username is the server address

Pierre Monico · Answer

If I replace the ` ` in the username as ` 40` url encoded it s the `graphql` service that throws an error `Error invalid interpolation syntax in lt my postgres url gt `

Pierre Monico · Answer

It s obviously very stupid that Azure sets the user in this format but I can t figure a workaround

Pierre Monico · Answer

And just to be precise I believe this happens when trying to run the Alembic migrations <https stackoverflow com questions 39849641 in flask migrate valueerror invalid interpolation syntax in connection string a|It seems to be this exact error>

Pierre Monico · Answer

Kevin Kho · Answer

Hey sorry I think a look at this but really can t think of anything to advice

Pierre Monico · Answer

Just filed an issue <https github com PrefectHQ server issues 330>

Kevin Kho · Answer

Sounds good

Julio Venegas · Answer

< Pierre Monico> maybe you ve solved it but I had this issue in the past Solved it with the snippet above

Julio Venegas · Answer

Also relevant <https docs prefect io orchestration server deploy local html external postgres instance>

Kevin Kho · Answer

Oh nice Could you chime in <https github com PrefectHQ server issues 330|here> also Julio

Julio Venegas · Answer

Sure