跳至內容
選單
此問題已被標幟

Hello, how can I back up odoo database from server and restore it to my personal computer using pgadmin? 

頭像
捨棄
最佳答案

Hi,

In the current case, you can directly restore the database from the UI or use terminals


If you restore the dump dile try this code in your terminal


$sudo su postgres

$createdb -O [Owner] [database_name]

$psql [database_name]



dump:

$sudo su postgres

$createdb -O [Owner] [database_name]

$pgrestore -d [database_name] [dumpfile_name].dump


for more reference you can refer to the Blog : 

https://www.cybrosys.com/blog/how-to-restore-a-database-in-odoo-15-erp



automatic datarestore-

https://www.cybrosys.com/blog/how-to-setup-automatic-database-backup-in-odoo-15


Hope it helps

頭像
捨棄
作者

The reason of using pgadmin is because:
1. Im bad at code
2. my odoo server is error and no one know how to resolve it.
So, if i use pgadmin, i just need to right-click the database, create backup using .tar file, right?

相關帖文 回覆 瀏覽次數 活動
2
5月 21
2433
3
3月 15
8384
0
3月 24
1315
1
3月 24
7946
4
12月 17
5230