Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8D83D650E9E for ; Tue, 1 Jul 2008 04:56:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 71337-01-7 for ; Tue, 1 Jul 2008 04:56:46 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from qb-out-0506.google.com (qb-out-0506.google.com [72.14.204.231]) by postgresql.org (Postfix) with ESMTP id 06EBA650F88 for ; Tue, 1 Jul 2008 04:32:27 -0300 (ADT) Received: by qb-out-0506.google.com with SMTP id c8so3910560qbc.39 for ; Tue, 01 Jul 2008 00:32:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type:references; bh=Fg+Ql5bKwcMIPI9E7MBm9N2+xnwitL6+IShIwrdQJhA=; b=dZ4b49bglgSmbYt9jvWixDvW+XzLWXhw+hjvRy2XGfk/PSbF/CGdQ6/i7cYAz02YcZ VkSQv9CmreYnqx15j4SGOGCU3dptkEYlfJ1V9/P0FQCIrkSYXolSFG1DUCk24vvYgKOk 1nrTp/pyBFSrNTbcRsUl/jDrJjYH4cXJbCAHg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:references; b=urBAeiIYMHKywOlqDZB4mOi4udq6i9uQ76Llcw1vJrGWau4W2S2SbAGA2ES7C99TG7 69ggtVIfyQZMgq9bJS5BXFLBh2Jtw5NteUpxPP9l6oRjAy3qUBQHsLQVayvVAep5ed29 nP+noWOvSCshFR7xJ/tctiZ19shJi0Jaw4VdM= Received: by 10.125.116.5 with SMTP id t5mr1313367mkm.104.1214897545878; Tue, 01 Jul 2008 00:32:25 -0700 (PDT) Received: by 10.125.96.10 with HTTP; Tue, 1 Jul 2008 00:32:25 -0700 (PDT) Message-ID: <9c3360200807010032v2f154417p47d2de7a3fa7b389@mail.gmail.com> Date: Tue, 1 Jul 2008 14:32:25 +0700 From: "ria ulfa" To: pgsql-admin@postgresql.org Subject: tanya ttg postgre di linux In-Reply-To: <9c3360200807010028n73e65920m409f76b74675fa72@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_17104_6078003.1214897545845" References: <9c3360200807010028n73e65920m409f76b74675fa72@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200807/2 X-Sequence-Number: 29612 ------=_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: ● 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 ------=_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)
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

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