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 يوليو 25	67730
how to backup ? تم الحل backup	9 يوليو 24	104405
Backup Odoo 12 database using Ubuntu command line backup	1 يوليو 22	5921
how to backup a saas database and restore on a local server تم الحل backup	12 يونيو 24	23258
i can't delete backup	0 أبريل 22	50

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!