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

Hello

I am trying to restore a database using the odoo database manager. Every thing goes right, the database is uploaded, and created in the system (postgresql) but it do not show in the database manager. There is only one database listed.

This happens in a production environment

Any help please?

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

Check odoo config file (odoorc) and make sure that dbfilter or db_name are not set 
ref: https://www.odoo.com/documentation/13.0/setup/deploy.html#configuration-samples

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

Hi

This exactly what I did , but the issue still exists

dbname = False is worked for me. Thanks.

I used to set dbname = my_db so it only show my_db in database manager.

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

Hi,

You can try the following in the psql

ALTER DATABASE database_name OWNER TO your_user;

Regards

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

Thank you for the answer, Unfortunately it wont work

This worked for me, thanks.

But it contradicts the recommendation in the official docs, that says the database owner should be a different user, so that it can't drop the database.

What should we do for enhanced security then?

Tác giả Câu trả lời hay nhất

Finally I solved this issue

I set the targeted database 

dbfilter = ^targeted_database$

db_name= targeted_database

Although it is not listed in the database manager , but it works fine

I noticed no side effect


Thank you

Ảnh đại diện
Huỷ bỏ

You will not have side effects as long as you have only one database. Please read the dbfilter chapter in the official deploying documentation.

Bài viết liên quan Trả lời Lượt xem Hoạt động
2
thg 12 23
3440
0
thg 8 23
1666
1
thg 3 23
3060
3
thg 7 19
4744
1
thg 11 23
1985