This question has been flagged
1 Reply
16498 Views
restoredbdumpterminalpostgresql9.3
Avatar
Jignesh Mehta

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,

Avatar
Discard
Avatar
Axel Mendoza
Best Answer

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

Avatar
Discard