Postgres Password with special characters
Hello!
The auto-generated postgres password includes specialc charaters which is causing errors on boot for my Ruby on Rails project. How can I update the password?
Solution:Jump to solution
- remove the active postgres deployment from its 3 dot menu
- generate a new 32 length password with this string
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-_.~
- update the POSTGRES_PASSWORD variable with the new password
- wipe the volume
- redeploy the database with this tool https://bookmarklets.up.railway.app/service-redeploy/...13 Replies
Project ID:
2e342c70-1e30-4a74-9347-cade6a6e2d7b2e342c70-1e30-4a74-9347-cade6a6e2d7b
how did you deploy postgres?
GitHub
GitHub - railwayapp-templates/ruby-rails
Contribute to railwayapp-templates/ruby-rails development by creating an account on GitHub.
the asterisk right?
Yup
interesting, rfc 3986 section 2.3. was referenced when putting together the available character string for the password, so i dont know how the asterisk slipped in.
this is the current string
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-_!~*
let me test if you are able to change the password after the database was deployedSolution
- remove the active postgres deployment from its 3 dot menu
- generate a new 32 length password with this string
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-_.~
- update the POSTGRES_PASSWORD variable with the new password
- wipe the volume
- redeploy the database with this tool https://bookmarklets.up.railway.app/service-redeploy/Thanks @Brody !
does that mean those steps worked for you?
@Brody - yea looks like that worked. Now I have to figure out why my web app isn't auto deploying from github pushes
do you have a branch selected
yup