More than one database in a PostgreSQL service
Hi, I'm new to Railway and I've seen that I can easily create a Postgres service that is set up with a database called
railway
. When I populate that database with tables, I can even navigate through the data in the UI dashboard.
I've connected to the Postgres instance and created a new database but I'm wondering if that could be a problem given that I can only see the railway
database. If I change the variable of the db name, I get an error in the Data tab (see attached image).
Is that expected? I can connect through psql.
Finally, I've changed the posgres_db
variable back to railway
and now I'm getting the same error again.
Thanks for your help.![No description](https://cdn.answeroverflow.com/1170841223100112936/image.png)
Solution:Jump to solution
theres nothing preventing anything really, the data tab is just simply unreliable, i always check whats in my database with a client like dbgate
6 Replies
Project ID:
N/A
N/A
The data tab is not reliable, I trust what any other client says over it. If psql is showing the tables then it shouldn't be a problem.
ok, so that's a known issue in the UI then?
I mean, no one is going to mess around with my other databases and delete them, right? I'm wondering if there's some automatic process preventing users from creating other databases aside from the one named
railway
.Solution
theres nothing preventing anything really, the data tab is just simply unreliable, i always check whats in my database with a client like dbgate
cool, good to know. Thanks for your help!