Title
#users-public
João Calapez

João Calapez

08/22/2022, 2:17 PM
Hello, i'm trying to find a way to change the name of the database from qdb to something else, I was expecting to see something in line with pg.password or pg.user, but cant find anything that defines this, any light on this?
Jaromir Hamala

Jaromir Hamala

08/22/2022, 2:28 PM
Hello, I believe the name of the database is ignored anyway. a single questdb instance does not support multiple databases at this moment. “qdb” is recommended to use as things can change in the future, but as of now you can use anything and it should work.
João Calapez

João Calapez

08/22/2022, 2:32 PM
I didn't quite catch the use anything part, what env var should I use? I'm not trying to create multiple db's in an instance, is just for the uniformization of a docke-compose file
Jaromir Hamala

Jaromir Hamala

08/22/2022, 2:35 PM
I apologize for the confusion. Let’s start from here: I’m assuming you are using a Postgres client to connect to QuestDB. Is that right? QuestDB documentation says you should configure Postgres drivers to use qdb as a database name when connecting to QuestDB. I understood you would like to use a different database name, not qdb, but some other name. Is that right too?
João Calapez

João Calapez

08/22/2022, 2:35 PM
Yup, so what you are saying is that the parameter dbname is ignored?
2:36 PM
That could work for my OCD
Jaromir Hamala

Jaromir Hamala

08/22/2022, 2:37 PM
yes, I checked the code and some tests and I could not find a case where the database name would be actually significant.
João Calapez

João Calapez

08/22/2022, 2:37 PM
Ok, this is something that might change in the near future?
Jaromir Hamala

Jaromir Hamala

08/22/2022, 2:37 PM
I changed postgres client tests to connect to a
notqdb
database and they are still passing.
2:40 PM
that’s a good question! probably not in a near future, I’m not aware of any plans to support multiple databases in a single questdb instance. but I cannot rule it out either. it would be quite significant change as it would affect other interfaces too. For example REST or ILP. Unlike Postgres they do not assume the existence of multiple databases. So such a change would be very highlighted in release notes.
João Calapez

João Calapez

08/22/2022, 2:42 PM
Ok, i've got enough info to keep going, thanks @Jaromir Hamala 🙂
Jaromir Hamala

Jaromir Hamala

08/22/2022, 2:42 PM
you are very welcome!