Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

dump create throw authentication failed when connection_uri includes special characters #300

Open
np-kyokyo opened this issue Jun 4, 2024 · 2 comments

Comments

@np-kyokyo
Copy link

np-kyokyo commented Jun 4, 2024

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
Copy link

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
Copy link

nickygb commented Nov 21, 2024

I have the same issue, any updates on this?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants