Skip to Content
Trebuie să fiți înregistrat pentru a interacționa cu comunitatea.
All Posts Oameni Insigne
Etichete (View all)
odoo accounting v14 pos v15
Despre acest forum
Această întrebare a fost marcată
backup
2 Răspunsuri
8232 Vizualizări
Imagine profil
Ram S

There are multiple ways to backup Database. Namely

  1. Backup from the Web client: Before login go to Database and create Backup Manually
  2. Auto Backup Module: Install Auto Backup Module and Schedule automatically
  3. Run Bash shell Script: Create a shell script and dump PostgresSQL database

My Questions are a. I need a reliable backup. If any issues I can restore and run smoothly. Is their any difference between the above 3. b. For Shell script we need to stop server. What is server runs 24x7 (Example manufacturing environment) and we can't stop the server. What are the best option?

Thank you

Imagine profil
Abandonează
Imagine profil
ton123
Cel mai bun răspuns

Three backups you mentioned are not sufficient. They are the easy part ....

You forget a very important thing: YOU NEED ALSO A BACKUP OF YOUR SOFTWARE If something break your software you need to repair or reinstall. If your Hardware fails you need to reinstall your software.

For these things I have:

  1. All installables including modules added scripts, added libraries, etc. Including descriptions of how to install.
  2. An identical hardware / software installation.
  3. An identical virtual machine with the OS and software installation.
  4. You need to test restore of database on a regular basis.
  5. You need to test recovery of OS and Hardware on a regular basis.
Imagine profil
Abandonează
GuruDev

Dear Ton,

Pelase let me know, how to accomplished these, Automatically?

ton123

@GuruDev I do not have the answer on this. I do it by hand.

Roberto Barreiro

My god! Same hardware too? And what happens if we change the server, the O.S. or another upgrade? I see this like a real problem!

Imagine profil
Gustavo
Cel mai bun răspuns

Chances are... something will go wrong with your server before going wrong with the database. So first I would take a look at backing up and restoring the server, specially the OpenERP server installation. Then I would backup the database with pg_dump, that does a pretty good job in backing up your database.

Now, if you need 24/7 availability, try replicating your database. PostgreSQL does a good job in replicating your DB

Imagine profil
Abandonează
Related Posts Răspunsuri Vizualizări Activitate
Database backup error: Postgres subprocess ('/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmpAa0O5Q/dump.sql', u'ahlain_db01') error 1 Rezolvat
backup
Imagine profil
Imagine profil
Imagine profil
Imagine profil
Imagine profil
9
iul. 25
67660
how to backup ? Rezolvat
backup
Imagine profil
Imagine profil
Imagine profil
Imagine profil
Imagine profil
9
iul. 24
104309
Backup Odoo 12 database using Ubuntu command line
backup
Imagine profil
Imagine profil
1
iul. 22
5903
how to backup a saas database and restore on a local server Rezolvat
backup
Imagine profil
Imagine profil
Imagine profil
Imagine profil
Imagine profil
12
iun. 24
23217
i can't delete
backup
Imagine profil
0
apr. 22
50