tanya ttg postgre di linux

------=_Part_17104_6078003.1214897545845
Content-Type: text/plain; charset=ISO-2022-JP
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

mw tanya: (sy pake fedora 7, dtbase postgreSQL)
1.    kalo mw copy isi tabel dlm dtbase ke flat file hrs masuk ke
dtbasenya
sbg user postgres kan?
2.    Command yg dpake apa?
3.    Sy ud nyoba:
       $B!|(B    masuk k postgre dg user postgres
       $B!|(B    command: simps=# COPY log TO '/root/do***ents/log.sql';
                $B!{(B    simps=nama dt base
                $B!{(B    log=nama tabel
                $B!{(B    log.sql=nama file tujuan
       tp muncul error:
       *could not open file "/root/do***ents/log.sql" for writing:
Permission denied*
       sy ud ubah mode do***ents dg chmod -Rf 777 do***ents, sy jg ud ubah
mode file log.sql agr root bs r,w,x. Tp errormsg nya te2p sama.
       namun, kalo pke cmd:   simps=# COPY log TO STDOUT;  isi tabel log
bs
lgsung muncul ke layar shell.
       kalo STDOUT dganti dg root file ko ga bisa??? padahal di man copy
bgtu ptnjuknya
4.    cr yg bener gmn ya???
5.    sgt diharapkan bantuannya. Terimakasih banyak

------=_Part_17104_6078003.1214897545845
Content-Type: text/html; charset=ISO-2022-JP
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

mw tanya: (sy pake fedora 7, dtbase postgreSQL)<br><div
class="gmail_quote">1.&nbsp;&nbsp;&nbsp; kalo mw copy isi tabel dlm dtbase
ke flat file hrs masuk ke dtbasenya sbg user postgres
kan?<br>2.&nbsp;&nbsp;&nbsp; Command yg dpake apa?<br>3.&nbsp;&nbsp;&nbsp;
Sy ud nyoba: <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $B!|(B&nbsp;&nbsp;&nbsp; masuk k
postgre dg user postgres<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $B!|(B&nbsp;&nbsp;&nbsp; command:
simps=# COPY log TO
&#39;/root/do***ents/log.sql&#39;;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
$B!{(B&nbsp;&nbsp;&nbsp; simps=nama dt
base<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
$B!{(B&nbsp;&nbsp;&nbsp; log=nama
tabel<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
$B!{(B&nbsp;&nbsp;&nbsp; log.sql=nama file
tujuan<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tp muncul error: <br>

&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; <b>could not open file
&quot;/root/do***ents/log.sql&quot; for writing: Permission
denied</b><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sy ud ubah mode
do***ents dg chmod -Rf 777 do***ents, sy jg ud ubah mode file log.sql agr
root bs r,w,x. Tp errormsg nya te2p sama.<br>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; namun, kalo pke cmd:&nbsp;&nbsp;
simps=# COPY log TO STDOUT;&nbsp; isi tabel log bs lgsung muncul ke layar
shell.<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; kalo STDOUT dganti dg root
file ko ga bisa??? padahal di man copy bgtu
ptnjuknya<br>4.&nbsp;&nbsp;&nbsp; cr yg bener gmn ya???<br>

5.&nbsp;&nbsp;&nbsp; sgt diharapkan bantuannya. Terimakasih banyak<br>
</div><br>

------=_Part_17104_6078003.1214897545845--