コンテンツへスキップ
この質問にフラグが付けられました
backuprestorelinuxodooV8
2 返信
12859 ビュー
アバター
Noah Alama

Hello, I have an Odoo 8 installation on an Ubunut 14.04 VPS, it's working like a charm, however, I'm afraid one day something bad might happen!

So, I don't want to relay on manual backups done through odoo's interface; 8069/web/database/manager#action=database_manager , I want to make this automatic using cron, so far, I've tried pg_dump, I'm able to extract a database, however, I don't know how to restore it, I've tried creating a new one and populating it with the old database, however, odoo doesn't recognize and show it!

Can you please help me, I'd like two command lines I can run on my linux installation, one for backing up my Odoo db and one for restoring it.

Thanks so much.

アバター
破棄
アバター
john sebastian salcedo henao
最善の回答

Hi, you can use this commands

create database your_db_name;

alter database your_db_name owner to odoo;

pg_restore -i -h localhost -p 5432 -U odoo -d your_db_name -v "your_db_name .backup"

アバター
破棄
Noah Alama
著作者

This seems very good, I'm going to give it a try when I go to work.

Do you have

Noah Alama
著作者

Do you have a command line for backing up odoo db, mine seems very weak, I use pg_dump dbname | gzip > dbname.gz

アバター
Ermin Trevisan
最善の回答

You might want to check the following module (more than 11000 downloads can't be wrong)  https://www.odoo.com/apps/modules/8.0/auto_backup/

アバター
破棄
Noah Alama
著作者

I use it already, thanks, but I'm unable to restore my db from its backups.

関連投稿 返信 ビュー 活動
How to Restore Odoo Online Database? 解決済
backup restore
アバター
アバター
アバター
アバター
3
9月 25
9572
Backup procedure for Odoo 14 CE 解決済
backup restore
アバター
アバター
1
5月 21
4893
Can't install auto_backup module 解決済
backup odooV8
アバター
アバター
アバター
アバター
アバター
16
9月 20
23086
using commang line pg_dump and pg_restore 解決済
database backup restore odooV8 shell
アバター
アバター
アバター
4
7月 18
14047
Alternates to backup?
backup odooV8
アバター
アバター
アバター
3
9月 17
3941