Odoo Help


How to resolve this error when restore .dump database from terminal ?

Jignesh Mehta
on 4/8/17, 2:42 AM 1,403 views


I had a .dump file for database and sizes of that database is around 350 MB.

Now i want to restore that database .dump file from terminal.

Right now, I am doing this way to restore

1) Take database .dump file from UI of Odoo.

2) Create New database using terminal

createdb new_db

3) Restore database .dump file using below command

pg_restore -d new_db -U root -C database_dump_file.dump

The following errors occurs while restoring database from .dump file

Error :-

pg_restore: WARNING:  no privileges could be revoked for "public"
pg_restore: WARNING:  no privileges could be revoked for "public"
pg_restore: WARNING:  no privileges were granted for "public"
pg_restore: WARNING:  no privileges were granted for "public"
WARNING: errors ignored on restore: 5817

Version of Postgresql  :-   PostgreSQL 9.3.15 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit

How to resolve this error?

How to restore database from terminal if taken .dump file from UI ?

Any suggestion will be Appreciated.



Axel Mendoza

--Axel Mendoza--
| 7 8 8
Camaguey, Cuba
--Axel Mendoza--

DevOps - Full stack - Software Architect - Developer - Technology Integrator

I could help you to develop anything and solve complex problems based on technologies, integrations and tricky stuffs mostly in Python with OpenERP/Odoo, Zato, Django and many others frameworks programming languages and technologies.

I offers consulting services to anyone with an unanswered questions or needs for customizations. Think about it, maybe it's better to have an expert to solve your issues and projects than having a full-time employee trying to understand what to do and how

Reach me at aekroft@gmail.com

Axel Mendoza
On 4/8/17, 11:06 PM

You need to create the db using the same postgresql user that it's used for Odoo, to be the owner of the database and the sql statements of the dump match properly... perhaps you could ignore the errors but it will be helpful to create the database using the same postgres user of Odoo or you won't be able to use it in that Odoo instance

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 4/8/17, 2:42 AM
Seen: 1403 times
Last updated: 4/10/17, 1:06 AM