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
Percy
Percy11mo ago
Project ID: 6eca6984-5b4b-40cd-9660-dab7e99f7321
Mario Paglia
Mario Paglia11mo ago
6eca6984-5b4b-40cd-9660-dab7e99f7321
Adam
Adam11mo ago
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.
Mario Paglia
Mario Paglia11mo ago
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.
Adam
Adam11mo ago
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
Want results from more Discord servers?
Add your server