Project

General

Profile

Actions
Copy link

Task #442

closed

test restoring of import backups

Added by Aaron Marcuse-Kubitza almost 12 years ago. Updated almost 12 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Aaron Marcuse-Kubitza
Start date:
07/16/2012
Due date:
% Done:

100%

Estimated time:
Activity type:
Actions
Copy link
 #1

Updated by Aaron Marcuse-Kubitza almost 12 years ago

Google techniques for this

Actions
Copy link
 #2

Updated by Aaron Marcuse-Kubitza almost 12 years ago

Options:

Actions
Copy link
 #3

Updated by Aaron Marcuse-Kubitza almost 12 years ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 100

I tested restoring by extracting the compressed, custom-format backup to a plain text SQL script1. This is much faster than restoring to DB, while still testing whether the archive is valid. For the most recent backup, I also tested restoring it on my local machine, which takes ~50 min2. (Backing up takes ~25 min3.)

1 make backups/public.<date>.backup/test &
Note that the compressed format is 9x smaller than plain text: 7.5 GB for all backups vs. 67.5 GB (75 GB - 7.5 GB after all were extracted)

2 make backups/public.2012-07-12-13-34-33.backup/restore & :

     3048.69 real        25.65 user         7.26 sys

3 make schemas/public.2012-07-12-13-34-33.backup & :

1508.94user 26.71system 25:57.51elapsed 98%CPU (0avgtext+0avgdata 38256maxresident)k
3448inputs+2220544outputs (57major+6427minor)pagefaults 0swaps

Actions
Copy link

Also available in: Atom PDF