pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: ria ulfa <riakdr@gmail.com>
To: pgsql-admin@postgresql.org
Subject: tanya ttg postgre di linux
Date: Tue, 1 Jul 2008 14:33:58 +0700
Message-ID: <9c3360200807010033g7a74dbbew652736c8af0917e8@mail.gmail.com> (raw)
In-Reply-To: <9c3360200807010028n73e65920m409f76b74675fa72@mail.gmail.com>
References: <9c3360200807010028n73e65920m409f76b74675fa72@mail.gmail.com>

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

view thread (3+ messages)

Message-ID: <9c3360200807010033g7a74dbbew652736c8af0917e8@mail.gmail.com>
Permalink:  ../9c3360200807010033g7a74dbbew652736c8af0917e8@mail.gmail.com/
Also on:    postgresql.org/message-id/9c3360200807010033g7a74dbbew652736c8af0917e8@mail.gmail.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: riakdr@gmail.com
  Subject: Re: tanya ttg postgre di linux
  In-Reply-To: <9c3360200807010033g7a74dbbew652736c8af0917e8@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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