Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
backuprestorelinuxodooV8
2 Vastaukset
12849 Näkymät
Avatar
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.

Avatar
Hylkää
Avatar
john sebastian salcedo henao
Paras vastaus

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"

Avatar
Hylkää
Noah Alama
Tekijä

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

Do you have

Noah Alama
Tekijä

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

Avatar
Ermin Trevisan
Paras vastaus

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/

Avatar
Hylkää
Noah Alama
Tekijä

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

Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
How to Restore Odoo Online Database? Ratkaistu
backup restore
Avatar
Avatar
Avatar
Avatar
3
syysk. 25
9558
Backup procedure for Odoo 14 CE Ratkaistu
backup restore
Avatar
Avatar
1
toukok. 21
4888
Can't install auto_backup module Ratkaistu
backup odooV8
Avatar
Avatar
Avatar
Avatar
Avatar
16
syysk. 20
23085
using commang line pg_dump and pg_restore Ratkaistu
database backup restore odooV8 shell
Avatar
Avatar
Avatar
4
heinäk. 18
14038
Alternates to backup?
backup odooV8
Avatar
Avatar
Avatar
3
syysk. 17
3939