تخطي للذهاب إلى المحتوى
القائمة
لقد تم الإبلاغ عن هذا السؤال
1 الرد
9042 أدوات العرض

When I installed odoo 9, I created a user named odoo(not a superuser). Using this user I can create and delete the database.

But when I am trying to back up my database, it shows no owner pg_dump. I am little confused about this situation. I tried to change the privilege of odoo user to superuser using the command "alter user 'odoo' with superuser"; but it does not alter the role. 

How can I give all privileges to my odoo user-backup, restore etc...?


الصورة الرمزية
إهمال
أفضل إجابة

Please update your question by explaining the method of backup, through a query or using third party application? If you are using a query then please pass user credentials as params.

for example:

pg_dump [dbname] -U username --role=rolename filename
الصورة الرمزية
إهمال
الكاتب

I had back up my database through odoo interface.

okay set admin_passwd in the conf file and update the security Postgres for odoo user in pg_hba file accordingly

المنشورات ذات الصلة الردود أدوات العرض النشاط
1
ديسمبر 24
6044
3
أغسطس 24
6895
4
يوليو 24
41203
5
أبريل 23
98953
3
نوفمبر 22
4326