Forums

Hello!

Hope everyone is having a great day! I was just wondering if there was a way to set different passwords for different databases. The reason being I would like to have a DEV server and a PROD server with different passwords.

I tried looking through the forum topics and help pages but this dosen't seem to have come up as a question before. Any help is appreciated!

Unfortunately we don't have a way to do that. But perhaps you could consider using a different account for the dev instance? If it doesn't use much in the way of resources, you could even use a free account for that.

In fact, now that I think about it -- one hack to make it work in the same account would be to create a new free account just for the dev database -- then you could provide a different password there. The dev environment could still run in your paid account, but would be accessing the DB belonging to the free one.

Thanks for that! Problem here unfortunately is that the free account only has limited space of 1 GB. The overall DB size for the current project I'm working on borders on 1GB and might exceed quite quickly. Plus, having access to it on Dbeaver helps in quick debugging if I screw up in the DB side.

Free accounts are limited to 512 MB. In the case you describe you may need two paid accounts. The other option is Postgres, where you can create multiple users as you are superuser there. On the other hand custom account with postgres is more expensive then two basic paid "Hacker" accounts.

Sorry for the late response. Thanks for that and I didnt know that Postgres has that functionality. Appreciate the suggestions!