Change postgreSQL database owner

Question

Hi,  I need to run an Odoo intance connected to a database hosted in the Cloud.
It looks that Odoo run fines if the database owner is the "odoo" user.
But if i change the database owner to "postgres", then i got the below error while Odoo backend loading :
Uncaught Error: QWeb2: Template 'PlannerLauncher' not found Any idea how to fix it ?
I need to keep it working with database owner "postgres".
Thanks and regards

Christophe Humbert · Answer

Hello
I am curious were you able to make it work at the end. And if yes can you tell me how?
Thanks

BeautyByMe SAS · Answer

I am using this DB in the cloud, so as i am on a cloud provider server, i am not admin.I cannot manage PostGres user so i am also not able to edit the pg_hba.conf. The goal would be to be able to use a cloud provider with odoo DB. Any idea why Odoo behavior is not the same if DB owner is "postgres" user ?

Ibrahim Boudmir · Answer

Hi,
did you try  to pass trust instead of md5 in your   /etc/postgresql/....../pg_hba.conf file ? like this:
host    all             all               trust

Gerelateerde posts	Antwoorden	Weergaven
How to move datastore to a different hard drive Odoo 10 CE? server database postgres	3 aug. 21	7518
Hosting for multi developers to work on a shared project database cloud heroku	0 mrt. 21	3602
Explore raw data Opgelost database api pgadmin postgres	2 dec. 21	5785
Where can we find a database scheme? Opgelost database v7 postgres scheme	7 dec. 23	73583
In Odoo, what is the purpose of the PostgreSQL database, and how does Odoo use it? database	0 mei 26	6

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!