[pgsql-jp: 38657] PGPASSWORD の利用で回避できました。 <-- Re: バックアップの自動化

[藤澤]

$B$9$_$^$;$s!#<ALd$r=P$7$?D>8e$K2r7h:v$,8+$D$+$j$^$7$?!#(B

$B%P%C%A$N ＠ hF,$G!"%Q%9%o!<%I$r4D6-JQ?t(B PGPASSWORD $B$K%;%C%H(B
$B$9$k$3$H$G!"%Q%9%o!<%IF~NO$r2sHr$G$-$^$7$?!#(B
    -------------------------------------------------------------
    set PGPASSWORD=hogehoge
    pg_dump -h hoge3 -d fujisawa -U hoge -F c -c -f d:\temp\fujisawa_dump.car

    pause
    -------------------------------------------------------------
$B<:Ni$7$^$7$?!#(B



$B"#=$@5$G$9!#(B
$B ＠ h$[$I$NJ8>O$NJT=8$b$l$G$9!#@5$7$/$O0J2<$N ＠ _Dj$G$9!#(B

    $B!'(B
$B-"(Bpg_hba.conf $B$K0J2<$N ＠ _Dj$r$7$F!"(BPostgreSQL $B$N%5!<%S%9$r:F5/F0$7$?$j(B
    -------------------------------------------------------------
    host    fujisawa    hoge        10.136.0.0/17    trust
    -------------------------------------------------------------
    $B!'(B
    $B!'(B



$B0J>e(B




On Fri, 17 Aug 2007 15:32:11 +0900 (JST)
$BF#_7(B <qsecofr1 ＠ hotmail.com> wrote:

> $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)
> ------------------------------------
> 
>