Solved

Linux Server Backup Guidance

Posted on 2015-01-11
4
260 Views
Last Modified: 2016-10-27
Hi folks

Just looking for some guidance on backing up a linux server regularly.

The server I have will be a very stable state ubuntu running postgresql and Odoo ERP services.

What I currently plan to do is:

  1. Have cron job that runs dump for my postgresql databases.
  2. Then cron runs tar to backup specific directories (including database dumps) to a local backup folder, then copies them to an external drive.
  3. When a restore is needed, I manually extract the files from external drive tar to a temporary folder on the target recovery machine. This machine is already setup identically to the server, e.g. running ubuntu, postgresql, and odoo.
  4. Copy needed files to appropriate folders (probably automate this).
  5. Restore database dumps.
  6. Enjoy running business on new Server? Profit?

Any advice please? Am wiling to spend significant money if there's a much easier/better way anyone can suggest?  e.g. Acronis.
0
Comment
Question by:ryanbe
  • 2
  • 2
4 Comments
 

Author Comment

by:ryanbe
ID: 40543637
Oh I should also mention I want ideally no downtime with the daily operation of this backup solution - maybe 10 minutes maximum at say 2am would be OK.
0
 
LVL 76

Expert Comment

by:arnold
ID: 40543655
If you already have two systems on hand with one "ready" to take over, why not look at having the second as a hot standby or better a functional load balance/......

Have a look at PostgreSQL replication or clustering.
http://wiki.postgresql.org/wiki/Replication%2C_Clustering%2C_and_Connection_Pooling

..........
Note your backups/DR should still be done just in case both .......... Fail
0
 

Author Comment

by:ryanbe
ID: 40545263
Hi arnold

That might be an option for later but for now am confident a single server will be able to handle the load. A one-off few hours downtime is OK should the server fail. Just want to keep things as simple as possible initially. Also I would like the backup server to be off-site. Acronis backup to the cloud is looking like a nice neat 'hands-free' solution.

I guess it's just a matter of developing a backup/restore procedure and testing and practicing it.
0
 
LVL 76

Accepted Solution

by:
arnold earned 500 total points
ID: 40545477
There are many options Bacula, Amanda, etc. though anything offsite has to either have a VPN or a static IP at least on one end.

I would argues that one establishes the setup one wants locally, then deals with the offsite part.
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Which NIC is live in Win/Linux? 25 73
People Counting Software 2 62
Squid Authentication 7 35
shadow copies 7 19
Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now