Doodba postgres odoo initialization bug or feature

[ap-wtioit]

Because we are setting POSTGRES_DB to *dbname at first start the postgres image is creating an empty database with dbname before Odoo is starting. Which prevents odoo from automatically initialising the db in _create_empty_database and forces us to use something like docker-compose run --rm odoo odoo -i base --stop-after-init to initialize the db.

Also this way the extensions (pg_trgm, unaccent) normally created by Odoo are not created in this initialization procedure in doodba.

Should we fix this or has it been implemented to long and do we leave it as a "feature"?

[pedrobaeza]

Well, if you find a mechanism for avoiding the problem/feature, please propose the PR.

[xavivars]

What would be then the process to create a DB in prod?

First start everything (docker-compose -f prod.yml up -d) and then do something like docker-compose run --rm odoo odoo -i base --stop-after-init to reinitialize the db?

[pedrobaeza]

Flip both commands.