跳至内容
此问题已终结
backuprestorelinuxodooV8
2 回复
12121 查看
形象
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
7月 24
7041
Backup procedure for Odoo 14 CE 已解决
backup restore
形象
形象
1
5月 21
4026
Can't install auto_backup module 已解决
backup odooV8
形象
形象
形象
形象
形象
16
9月 20
22027
using commang line pg_dump and pg_restore 已解决
database backup restore odooV8 shell
形象
形象
形象
4
7月 18
13125
Alternates to backup?
backup odooV8
形象
形象
形象
3
9月 17
3339