Output sql_insert with postgres fails if password contains { character

[TunaYagci]

Hey there, if the password contains { character, sql_insert for postgres driver fails with:

Failed to send message to sql_insert: parse "postgres://omitted": net/url: invalid userinfo

tested with the latest docker container

[rockwotj]

Hey @TunaYagci you need to URL escape passwords in the dsn.

[TunaYagci]

Hey @TunaYagci you need to URL escape passwords in the dsn.

You mean escaping the url in my local and using that value in the configuration, right? Assuming I have dsl config like:

postgres://user:testPassword{}@host:5432/db

And I escape the password in my local like:

fmt.Println(url.QueryEscape("testPassword{}")); // outputs testPassword%7B%7D

so I replaced my dsn like:

postgres://user:testPassword%7B%7D@host:5432/db

this solves the net/url issue but sadly leads to connection errors:

Failed to send message to sql_insert: read tcp ip1->ip2:5432: read: connection reset by peer

Can I escape the password directly in the config somehow? I thought DSN field doesn't support interpolation.

[rockwotj]

DSN does not support interpolation and at the moment it is not possible to apply these transformations at the moment for secret values either.

[TunaYagci]

mine was a network issue, it got resolved now. I think it would be nice if this URL escape detail is mentioned in the docs. thanks for the help!