1 |
#!/usr/bin/perl |
2 |
|
3 |
# split PostgreSQL dump into individual files for backup with git |
4 |
# |
5 |
# 09/11/08 20:10:39 CEST Dobrica Pavlinusic <dpavlin@rot13.org> |
6 |
|
7 |
use warnings; |
8 |
use strict; |
9 |
|
10 |
use Getopt::Long; |
11 |
use Fatal qw/:void open close mkdir chdir/; |
12 |
my $git = '/tmp/pgsql-git-backup/'; |
13 |
my $verbose = 0; |
14 |
my $database = ''; |
15 |
my $repack = 1; |
16 |
|
17 |
my $usage = "Usage: $0 --database name < name-dump.sql\n"; |
18 |
|
19 |
GetOptions( |
20 |
'git=s' => \$git, |
21 |
'database=s' => \$database, |
22 |
'verbose+' => \$verbose, |
23 |
'repack' => \$repack, |
24 |
) or die $usage; |
25 |
|
26 |
die $usage unless $database; |
27 |
|
28 |
my $nr = 0; |
29 |
my $name = $database; |
30 |
my $d; |
31 |
|
32 |
sub git { |
33 |
my $cmd = shift or die "no cmd?"; |
34 |
system($cmd) == 0 or die "$cmd FAILED $?"; |
35 |
} |
36 |
|
37 |
sub write_chunk { |
38 |
my $path = sprintf("%s/%04d%s.sql", $database, $nr++, $name); |
39 |
open(my $fh, '>', $path) or die "can't open file $path: $!"; |
40 |
print $fh $d; |
41 |
close($fh); |
42 |
warn ">> $path ", -s $path, "\n" if $verbose; |
43 |
git "git-add '$path'"; |
44 |
} |
45 |
|
46 |
mkdir $git if ! -e $git; |
47 |
|
48 |
chdir $git; |
49 |
warn "## using $git\n" if $verbose; |
50 |
|
51 |
git 'git-init-db' if ! -e "$git/.git"; |
52 |
|
53 |
if ( ! -e $database ) { |
54 |
mkdir $database; |
55 |
# git "git-add '$database'"; |
56 |
# git "git-commit -m 'added $database directory' $database"; |
57 |
} |
58 |
|
59 |
while(<STDIN>) { |
60 |
if (/-- Name: (.+?);/) { |
61 |
write_chunk; |
62 |
$name = " $1"; |
63 |
$name =~ s/\W+/ /g; |
64 |
undef $d; |
65 |
$d = ''; |
66 |
} |
67 |
$d .= $_; |
68 |
} |
69 |
|
70 |
write_chunk; |
71 |
|
72 |
git "git-commit -m '$database' '$database'"; |
73 |
|
74 |
git "git-repack" if $repack; |
75 |
|