How do I change the username and password for my PostgreSQL instance?
I created a new PostgreSQL instance, changed the environment variables but I can't connect because it says that the username or password are invalid. Just changing the environment variable and performing a new deployment automatically changes the settings or do I need to do something different in this case?
5 Replies
Project ID:
6eca6984-5b4b-40cd-9660-dab7e99f73216eca6984-5b4b-40cd-9660-dab7e99f7321
changing the environment variable does not change the username/password. Those fields are set up when you create the database and cannot be changed from within Railway
a database client could probably change them/add new ones, but Railway cannot.
Got it, thank you very much for the answer. In fact, when I create a database, it doesn't ask me what username and password I want to enter, it already created it on its own.
Some databases do ask you, some don’t. They’re secure all the same
you shouldn’t need to change your user/password unless you need to add multiple users with different permissions to the database