Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
2 Trả lời
4073 Lượt xem

Hi, I restored new dump in my odoo by PSQL. Database created in PG admin and tables created. But database not showing in frontent.

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

Hi,

You can solve this issue by refer the following link

https://www.odoo.com/forum/help-1/question/restoring-database-from-odoo-sh-using-dumb-sql-152714#answer-152716

Ảnh đại diện
Huỷ bỏ
Tác giả

I have to do in command line ?

Create database database_name;

ALTER USER your_user WITH SUPERUSER;

psql database_name < dump.sql

ALTER DATABASE database_name OWNER TO your_user;

i think in your case you have to do that last code for setting the owner

Tác giả

Actually I used this command to create database psql -h ip -d database name -U openpg -f D:\backup\dump.sql

can you use the above code for making backup, i think it will work smoothly

Tác giả

I changed Owner of the database in PG admin and my issue solved. Thanks every one...

Câu trả lời hay nhất

Hi Dhivya,

Check Owner of you database, this is may the problem.

Regards,

Silvestar

Ảnh đại diện
Huỷ bỏ
Tác giả

Can you explain the steps to restore? So that I can identify in which step i did mistake.