dump create throw authentication failed when connection_uri includes special characters

[np-kyokyo]

The following URL works fine for dump create:

postgres://root:password@localhost:50001/sample_db

However, if the password contains special characters like the following, it doesn’t work:

postgres://root:pass`word@localhost:50001/sample_db

For example, the following command works, so it seems to be a specific issue with Replibyte:

DATABASE_URL=postgresql://root:pass`word@localhost:50001/ec_recommend_db bun prisma db pull

This issue might not be limited to just the backquote character `, also occur on other special characters as well.

error output:

> replibyte -c replibyte.conf.yml dump create
⠁ 
command error: pg_dump: error: connection to server at "localhost" (::1), port 50001 failed: FATAL:  password authentication failed for user "root"
⠴ [00:00:00] [-------------------------------------] 0B/100.00MiB (0s)

[keinsell]

I can confirm, I could not authenticate every time my database had secure password with special characters. Providing password as encodedURI also do not work.

[nickygb]

I have the same issue, any updates on this?

[pepoviola]

Hi this should be fixed in https://github.com/Qovery/Replibyte/pull/291, but there isn't a release yet. (ping @evoxmusic can we draft a new release). A workaround is just compile from main and use that binary. Thx!