Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 372E1650142 for ; Fri, 18 Jul 2008 08:30:32 -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 26605-03 for ; Fri, 18 Jul 2008 08:30:24 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from easy2.in-chemnitz.de (easy2.in-chemnitz.de [88.198.17.232]) by postgresql.org (Postfix) with ESMTP id B643C650140 for ; Fri, 18 Jul 2008 08:30:28 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by easy2.in-chemnitz.de (Postfix) with ESMTP id 4FD72470008 for ; Fri, 18 Jul 2008 13:30:26 +0200 (CEST) Received: from easy2.in-chemnitz.de ([127.0.0.1]) by localhost (easy.in-chemnitz.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id gVIAOBpi297V for ; Fri, 18 Jul 2008 13:30:26 +0200 (CEST) Received: by easy2.in-chemnitz.de (Postfix, from userid 1013) id 3E972470005; Fri, 18 Jul 2008 13:30:26 +0200 (CEST) Date: Fri, 18 Jul 2008 13:30:26 +0200 From: Tino Schwarze To: pgsql-admin@postgresql.org Subject: Re: answer my question, please!!! Message-ID: <20080718113026.GB22470@easy2.in-chemnitz.de> References: <9c3360200807180229u16c49b30m442f0937cf29d59f@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <9c3360200807180229u16c49b30m442f0937cf29d59f@mail.gmail.com> User-Agent: Mutt/1.5.13 (2006-08-11) 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/159 X-Sequence-Number: 29769 On Fri, Jul 18, 2008 at 04:29:42PM +0700, ria ulfa wrote: > i want to copy table from file with command: > COPY log FROM '/tmp/logfile.txt'; > but there is error: > ERROR: could not open file "/tmp/logfile.txt" for reading: Permission > denied > what can i do for repair this error?? > thanks for the answer.. The file is read by the server process, therefore, the user the server process runs as needs read permissions for the file. HTH, Tino. PS: The more exclamation marks you use, the lower get the chances that you're taken serious and actually get a response. -- 'Multiple exclamation marks,' he went on, shaking his head, 'are a sure sign of a diseased mind.' (Terry Pratchett) www.craniosacralzentrum.de www.forteego.de