Database list only showing 1 database

Question

I have created 3 databases, but when I run ./odoo-bin only one db is shown (the database name is ben like  the OS user).
I searched the forums and I get that it should be related to the owner of the database in postgresql, but the 3 databases have the same owner (ben).
The odoo.conf has these lines:
db_host = False  db_maxconn = 64  db_name =  db_password = False  db_port = False  db_sslmode = prefer  db_template = template0  db_user = False  dbfilter = .*
but dbfilter there does not seem to wor

Mehjabin Farsana · Answer

Hi,
If you specify db_filter or db_name in the odoo configuration file, then you will get only filtered databases.
Suppose if you set a db filter, then db's matching given filter will be listed and if you specify db_name in conf file, only that database will be shown.
Also if you are running via service file or command line, make sure you didn't pass db name in -d
Thanks

Hilar Andikkadavath · Answer

You only need this min configuration to run ODOO.
db_host = localhost
db_port = 5432
db_password = postgres
db_user = odoo
xmlrpc_port = 8013
debug_mode = False
;data_dir=/home/dell/.local/share/Odoo/filestore
addons_path = /opt/odoo/addons  make sure you needed db_template, db_name, db_filter.
You don't need to specify db_filter if you need full list of dbs

Related Posts	Replies	Views
Can't find my odoo.conf file after installing odoo 17 on debian 12 odoo.conf	2 Dec 23	8526
How to splice lines for odoo.conf file configuration Solved odoo.conf	1 Nov 22	3232
Where is the the file odoo.conf in Odoo 13? Solved odoo.conf	1 Nov 23	62428
How to set default database for anonymous user? db_filter	2 Oct 16	9645
[NOT SOLVED yet] I can't set up/push my module with odoo.conf addons_path or scaffold command modules odoo.conf	2 Oct 23	583

This question has been flagged

Enjoying the discussion? Don't just read, join in!