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

Verknüpfte Beiträge	Antworten	Ansichten
How to move datastore to a different hard drive Odoo 10 CE? server database postgres	3 Aug. 21	7667
Hosting for multi developers to work on a shared project database cloud heroku	0 März 21	3726
Explore raw data Gelöst database api pgadmin postgres	2 Dez. 21	6019
Where can we find a database scheme? Gelöst database v7 postgres scheme	7 Dez. 23	73805
In Odoo, what is the purpose of the PostgreSQL database, and how does Odoo use it? database	0 Mai 26	6

Diese Frage wurde gekennzeichnet

Diskutieren Sie gerne? Treten Sie bei, statt nur zu lesen!