pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedtanya ttg postgre di linux
3+ messages / 1 participants
[nested] [flat]
* tanya ttg postgre di linux
@ 2008-07-01 07:28 ria ulfa <riakdr@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: ria ulfa @ 2008-07-01 07:28 UTC (permalink / raw)
To: pgsql-admin
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:
● masuk k postgre dg user postgres
● command: simps=# COPY log TO '/root/documents/log.sql';
○ simps=nama dt base
○ log=nama tabel
○ log.sql=nama file tujuan
tp muncul error:
*could not open file "/root/documents/log.sql" for writing:
Permission denied*
sy ud ubah mode documents dg chmod -Rf 777 documents, 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* tanya ttg postgre di linux
@ 2008-07-01 07:32 ria ulfa <riakdr@gmail.com>
parent: ria ulfa <riakdr@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: ria ulfa @ 2008-07-01 07:32 UTC (permalink / raw)
To: pgsql-admin
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:
● masuk k postgre dg user postgres
● command: simps=# COPY log TO '/root/documents/log.sql';
○ simps=nama dt base
○ log=nama tabel
○ log.sql=nama file tujuan
tp muncul error:
*could not open file "/root/documents/log.sql" for writing:
Permission denied*
sy ud ubah mode documents dg chmod -Rf 777 documents, 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* tanya ttg postgre di linux
@ 2008-07-01 07:33 ria ulfa <riakdr@gmail.com>
parent: ria ulfa <riakdr@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: ria ulfa @ 2008-07-01 07:33 UTC (permalink / raw)
To: pgsql-admin
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:
● masuk k postgre dg user postgres
● command: simps=# COPY log TO '/root/documents/log.sql';
○ simps=nama dt base
○ log=nama tabel
○ log.sql=nama file tujuan
tp muncul error:
*could not open file "/root/documents/log.sql" for writing:
Permission denied*
sy ud ubah mode documents dg chmod -Rf 777 documents, 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-07-01 07:33 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-07-01 07:28 tanya ttg postgre di linux ria ulfa <riakdr@gmail.com>
2008-07-01 07:32 ` ria ulfa <riakdr@gmail.com>
2008-07-01 07:33 ` ria ulfa <riakdr@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox