Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5957D65102D for ; Tue, 1 Jul 2008 06:46:13 -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 90301-02-4 for ; Tue, 1 Jul 2008 06:45:14 -0300 (ADT) X-Greylist: delayed 00:14:06.020295 by SQLgrey-1.7.6 Received: from mail.transporeon-hq.com (mail.transporeon-hq.com [213.179.145.36]) by postgresql.org (Postfix) with ESMTP id 8555A650EEA for ; Tue, 1 Jul 2008 06:15:14 -0300 (ADT) Received: from localhost ([127.0.0.1]) by mail.transporeon-hq.com with esmtp (Exim 4.69) (envelope-from ) id 1KDbjJ-00051N-FL; Tue, 01 Jul 2008 11:00:53 +0200 X-Virus-Scanned: Scanned by transporeon.com Received: from mail.transporeon-hq.com ([127.0.0.1]) by localhost (mail.transporeon.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id jTUYEBzr49Tz; Tue, 1 Jul 2008 11:00:52 +0200 (CEST) Received: from gw.transporeon-hq.com ([213.179.145.34] helo=[172.28.8.2]) by mail.transporeon-hq.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1KDbjH-00051H-RE; Tue, 01 Jul 2008 11:00:52 +0200 Message-ID: <4869F243.8030602@transporeon.com> Date: Tue, 01 Jul 2008 11:00:51 +0200 From: =?ISO-8859-2?Q?Gerd_K=F6nig?= User-Agent: Thunderbird 2.0.0.14 (X11/20080421) MIME-Version: 1.0 To: ria ulfa CC: pgsql-admin@postgresql.org Subject: Re: ask...!!! References: <9c3360200807010112g781b4521v88b1fd2c7c400b8c@mail.gmail.com> In-Reply-To: <9c3360200807010112g781b4521v88b1fd2c7c400b8c@mail.gmail.com> X-Enigmail-Version: 0.95.6 OpenPGP: id=CE188E9F Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200807/7 X-Sequence-Number: 29617 Hello, I don't think it's a good idea to store it under the /root directory, since "normal" users like e.g. postgres don't have write permission there (as the error message tells you). You have to choose a directory where your database user definitely has write permission. bye-GERD- ria ulfa schrieb: > i use linux fedora 7 and database PostgreSQL 8. > i want to copy table in postgre to a file. > i used code : simps=# COPY log TO '/root/documents/log.sql'; > note= simps: name of database > but there is error: could not open file "/root/documents/log.sql" for > writing: Permission denied > what can i do for repair this error?? >