Odoo Hilfe

0

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

Von
Jignesh Mehta
on 08.04.17 02:42 2.926 Ansichten

Hello,


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.

Thanks,

1

Axel Mendoza

--Axel Mendoza--
13143
| 7 8 8
Camaguey, Kuba
--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
An 08.04.17 23:06

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

Über diese 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.

Register

Odoo Training Center

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

Test it now

Hilfeforum

1 Verfolger

Statistik

Fragestellung: 08.04.17 02:42
Gesehen: 2926 -mal
Zuletzt aktualisiert: 10.04.17 01:06