Special characters in passwords breaks Prisma migrations
If using a password that contains special characters it might break Primsa migrations and cause the web pods to fail. This can be resolved with special formatting and SQL.
For every non alpha-numeric character we replaced it with the value outlined in: https://stackoverflow.com/questions/63684133/prisma-cant-connect-to-postgresql
Change the password in your database, and secret if used in your deployment.
Select a new password to use.
Exec into db container, log into psql as postgres
kubectl exec -n <NAMESPACE> -it <DATABASE-POD-NAME> -- bash
psql -u postgres
ALTER USER postgres WITH PASSWORD 'newpassword';
Exit the Postgres container and pod
If a kubernetes secret is being used you must edit the secret to reflect the password changed in the steps above:
Change the
databaseSuperuserPassword
in theimmuta-secrets
kubernetes Secret to reflect the new passwordPostgres passwords must be base64 encrpyted prior to saving or altering outside of SQL:
echo "newpassword" | base64
Save the secret
Last updated