Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Projekti
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

Setting up automatic backups for OpenERP 7

windows automated backup

1 Vastaa

10400 Näkymät

Laurens

I am very interested in setting up an automatic backup, so I don't have to manually backup the database multiple times a day. After taking a look at this and this post, I'm not sure whether I can use such a solution on my platform. I am using Windows Server 2003 to host my OpenERP package, can I make use of crontab as explained by Arif in the second post?

I never did something like this before, so any information given on this topic would be very much appreciated. I love using and learning from OpenERP, but it's not easy to do so when nearly all information seems to be written specifically for Linux.

Brett Lehrer

Paras vastaus

This is something you'd want to read through. http://wiki.postgresql.org/wiki/Automated_Backup_on_Windows

At any rate, I'd still suggest at least running a virtual machine with Ubuntu (or whatever other *nix distro you'd prefer otherwise) to host OpenERP on, rather than directly on Windows. The performance gain even in that scenario is worth looking into, and the support is much better. OpenERP is written on and for Linux, just ported to Windows.

Laurens

Tekijä

Thank you, Brett. This information is exactly what I was looking for!

I am aware hosting the server on a linux machine will boost the performance and loading times. I'll look into a guide to facilitate such a transition a little later, right now I'm cautious (read: afraid) of losing any data of our production database or creating too much down-time during the execution. I guess I'm still a newbie compared to some posters here, but I'm learning a lot each day.

Either way I greatly appreciate you taking the time to supply me this information. Thanks again, Brett. :)

Mike Lindsay

The nifty thing about OpenERP's data management, take a backup of your database on your Windows box, then restore that backup to your Linux box. You can leave your windows box running until your 100% satisfied with your linux box, then just repeat the procedure when your ready to go live.

KOMIT COMPANY LIMITED, Jean-Charles Drubay

Hi, for a full backup, you should backup: - Database - Source code - Attached files: this is true in the case you decided to store documents outside of the database

Gopal Patel

@Jean I thought openerp saves everything in database ?

Brett Lehrer

You can choose to store binaries/files outside of the database. The database record would still be there, but the binary field would be left empty.

Nadeem Ahmed

Thanks Brett, thats what I was looking for. For me I have no experience on Linux and trouble is I have plenty of other software which runs only on windows and that need a backup too.

Sheilon Wunder

Dear Brett, I too am running OpenERP in Windows Server 2003. However, I was not able to follow the steps to create a backup. I ran into all sorts of issues including error messages that indicated me not being able to communicate to DB Template1. Hence, I tried to use pg_dumpall.exe from the command line. This also caused issues as I don't know what would be all the parameters. Shouldn't I try to backup as the superuser? If so what is the user name? Could you please help?

Gilles Lehoux

If you've installed a module manually, by copying it to an addons folder, then be careful to copy that module before attempting to restore your database or else...

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Automated Backup -- for Odoo to Synology automated synology backup	2 marrask. 19	6104
auto backup windows windows backup pysftp	1 heinäk. 17	6973
Migrated odoo to the new laptop and the CRM app is not working anymore (UncaughtPromiseError > TypeError) windows crm migration backup	0 toukok. 23	2173
Trying to automatically update analytic distribution in purchase order Ratkaistu automated	3 kesäk. 25	3563
Database backup error: Postgres subprocess ('/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmpAa0O5Q/dump.sql', u'ahlain_db01') error 1 Ratkaistu backup	9 heinäk. 25	67171

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!