Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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
Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !
S'inscrire| Publications associées | Réponses | Vues | Activité | |
|---|---|---|---|---|
|
1
déc. 24
|
6314 | ||
|
3
août 24
|
7133 | ||
|
4
juil. 24
|
41639 | ||
|
Default value in form view
Résolu
|
|
5
avr. 23
|
99667 | |
|
3
nov. 22
|
4600 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
