Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hello
I am trying to restore a database using the odoo database manager. Every thing goes right, the database is uploaded, and created in the system (postgresql) but it do not show in the database manager. There is only one database listed.
This happens in a production environment
Any help please?
Check odoo config file (odoorc) and make sure that dbfilter or db_name are not set
ref: https://www.odoo.com/documentation/13.0/setup/deploy.html#configuration-samples
Hi
This exactly what I did , but the issue still exists
dbname = False is worked for me. Thanks.
I used to set dbname = my_db so it only show my_db in database manager.
Hi,
You can try the following in the psql
ALTER DATABASE database_name OWNER TO your_user;
Regards
Thank you for the answer, Unfortunately it wont work
This worked for me, thanks.
But it contradicts the recommendation in the official docs, that says the database owner should be a different user, so that it can't drop the database.
What should we do for enhanced security then?
Finally I solved this issue
I set the targeted database
dbfilter = ^targeted_database$
db_name= targeted_database
Although it is not listed in the database manager , but it works fine
I noticed no side effect
Thank you
You will not have side effects as long as you have only one database. Please read the dbfilter chapter in the official deploying documentation.
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
