- Added user to database (https://www.sqlai.ai/snippets/clr50d8sq0001m62tm4k8jr5w) - Switched the user and password in the default DATABASE_URL and tried to connect - I get "Invalid URL" error Do I need to add the user/password anywhere to be able to connect from outside?

Connect to PostgreSQL database using added read only user?

lassegit

HOBBYOP

2 years ago

Added user to database (https://www.sqlai.ai/snippets/clr50d8sq0001m62tm4k8jr5w)
Switched the user and password in the default DATABASE_URL and tried to connect
I get "Invalid URL" error

Do I need to add the user/password anywhere to be able to connect from outside?

3 Replies

brody

EMPLOYEE

2 years ago

when running those commands on your database to create a read-only username and password, did you use credentials with only valid characters that don't need to be url escaped?

lassegit

HOBBYOP

2 years ago

That was it, thanks 🙏.

brody

EMPLOYEE

2 years ago

no problem!