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

関連投稿	返信	ビュー
Database backup error: Postgres subprocess ('/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmpAa0O5Q/dump.sql', u'ahlain_db01') error 1 解決済 backup	9 7月 25	67842
how to backup ? 解決済 backup	9 7月 24	104642
Backup Odoo 12 database using Ubuntu command line backup	1 7月 22	5979
how to backup a saas database and restore on a local server 解決済 backup	12 6月 24	23346
i can't delete backup	0 4月 22	50

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！