Multiple Backup methods and its differences

Question

There are multiple ways to backup Database. Namely
Backup from the Web client: Before login go to Database and create Backup Manually
Auto Backup Module: Install Auto Backup Module and Schedule automatically
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 ma

ton123 · Accepted Answer

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:

All installables including modules
added scripts, added libraries, etc.
Including descriptions of how to
install.
An identical hardware / software
installation.
An identical virtual machine with

Gustavo · Answer

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

Related Posts	ตอบกลับ	มุมมอง
Database backup error: Postgres subprocess ('/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmpAa0O5Q/dump.sql', u'ahlain_db01') error 1 แก้ไขแล้ว backup	9 เม.ย. 25	62884
how to backup ? แก้ไขแล้ว backup	9 ก.ค. 24	94901
Backup Odoo 12 database using Ubuntu command line backup	1 ก.ค. 22	4177
how to backup a saas database and restore on a local server แก้ไขแล้ว backup	12 มิ.ย. 24	20644
i can't delete backup	0 เม.ย. 22	50

คำถามนี้ถูกตั้งค่าสถานะ

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!