[pgsql-jp: 38656] バックアップの自動化

[藤澤]

$BF#_7$G$9!#(B


$B%P%C%/%"%C%W$N<+F02=$r$7$?$$$N$G$9$,!"=PMh$F$$$^$;$s!#(B(T-T


SQL Server 2000 $B$N(B SQL Agent $B$N$h$&$J$b$N$,$"$k$+$HC5$7$^$7$?$,!"(B
$B8+$D$+$j$^$;$s$G$7$?$N$G!"(Bpg_dump $B$r<B9T$9$k%P%C%A$r%?%9%/$K(B
$BEPO?$7$?$$$H9M$($F$$$^$9$,!"%Q%9%o!<%I$rJ9$$$F$/$k$?$a!"$3$l$b(B
$BIT2DG=$+$b$7$l$J$$!"$H9M$(;O$a$F$$$^$9!#(B(pg_dump $B$N%9%$%C%A$K$O(B
$B%Q%9%o!<%I;XDj$OL5$$$G$9$7!#!#!#(B)
    -------------------------------------------------------------
    rem $B%[%9%H!V(Bhoge3$B!W>e$N%G!<%?%Y!<%9!V(Bfujisawa$B!W$N%@%s%W$r<hF@$9$k(B
    pg_dump -h hoge3 -d fujisawa -U hoge -F c -c -f d:\temp\fujisawa_dump.car

    pause
    -------------------------------------------------------------


$B%Q%9%o!<%I$rJ9$$$F$3$J$$$h$&$K$7$?$$$H;W$$!"(B
$B-!(Bpgpass.conf $B$K(B
    -------------------------------------------------------------
    hoge3:*:fujisawa:hoge:hogehoge
    -------------------------------------------------------------
  $B$H5-=R(B(hostname:port:database:username:password)$B$7$?$j!"(B

$B-"(Bpg_hba.conf $B$K0J2<$N ＠ _Dj$r$7$F!"(BPostgreSQL $B$N%5!<%S%9$r:F5/F0$7$?$j(B
    -------------------------------------------------------------
    # TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK         METHOD
    host    all         all         127.0.0.1         255.255.255.255 trust
    -------------------------------------------------------------
    (http://ml.postgresql.jp/pipermail/pgsql-jp/2005-February/018352.html $B$h$j(B)

$B$J$I9T$$$^$7$?$,!"%Q%9%o!<%I$rJ9$$$F$-$^$9!#(B


$B%P%C%/%"%C%W$r<+F02=$7$F$$$kJ}$OBt;3$$$i$C$7$c$k$O$:$J$N$G!"(B
$B2?$i$+$NJ}K!$,$"$k$H;W$C$F$$$^$9!#(B
$B$4B8$8$NJ}$$$i$C$7$c$$$^$7$?$i!"65$($F2<$5$$!#$h$m$7$/$*4j$$$7$^$9!#(B




$B"#4D6-(B
------------------------------------
$B%[%9%H!V(Bhoge3$B!W(B
    Windows Server 2003 SP2
    PostgreSQL 8.2.4
    $B%G!<%?%Y!<%9L>(B  fujisawa
    $B@\B3%f!<%6L>(B    hoge
    $B%Q%9%o!<%I(B      hogehoge
    $B"(%5!<%S%9:F5/F0$J$I$O!"%j%b!<%H%G%9%/%H%C%W$G<B;\!#(B
$B%/%i%$%"%s%H(B
    Windows Vista
    PostgreSQL 8.2.4  ($B%G!<%?%Y!<%9$b%/%i%$%"%s%H$bF3F~(B)
------------------------------------