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,