Please help: Error using password in connect string

[JamesInform]

Hi,

I want to connect to my PostgreSQL server:
Host: 127.0.0.1
Port: 5432
User: postgres
Password: mypass12#
Database: postgres

When I use the following connect:
conn, err := pgx.Connect(context.Background(), "postgres://postgres:mypass12#@127.0.0.1:5432/postgres")

I get this error
Unable to connect to database: cannot parse postgres://postgres:xxxxxx@127.0.0.1:5432/postgres: failed to parse as URL (parse "postgres://postgres:mypass12": invalid port ":mypass12" after host)

The error seems to appear when using "#" as a character for the password.

The same connect string works just fine when using it with psql:
psql postgres://postgres:mypass12#@127.0.0.1:5432/postgres

[jackc]

That's the behavior of the Go URL parser. See https://go.dev/play/p/VDrGGZWm-vW.

You could use DSN style connection string instead.

pgx.Connect(context.Background(), "user=postgres password=mypass12# host=127.0.0.1 port=5432 dbname=postgres")

[JamesInform]

Thanks, that works.

Are you judging the parser to be buggy concerning this issue and will there be a fix?

[jackc]

After a little further research, both PostgreSQL and Go claim to follow RFC 3986. But psql is not actually strictly following the RFC.

Your connection string is invalid. A # must be percent escaped. (e.g. https://go.dev/play/p/1WITfElDTgr)