Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B51BD65015C for ; Sat, 19 Jul 2008 07:41:24 -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 38890-09 for ; Sat, 19 Jul 2008 07:41:20 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 4C6BA650129 for ; Sat, 19 Jul 2008 07:41:24 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id m6JAfJhV044256 for ; Sat, 19 Jul 2008 07:41:19 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id m6JAPGGb032453 for pgsql-admin@postgresql.org; Sat, 19 Jul 2008 07:25:16 -0300 (ADT) (envelope-from news) From: chris X-Newsgroups: pgsql.admin Subject: Re: answer my question, please!!! Date: Fri, 18 Jul 2008 15:48:06 -0400 Organization: Hub.Org Networking Services Lines: 24 Message-ID: <87iqv3ug7d.fsf@dba2.int.libertyrms.com> References: <9c3360200807180229u16c49b30m442f0937cf29d59f@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.110006 (No Gnus v0.6) XEmacs/21.4.21 (linux) Cancel-Lock: sha1:FxxvQmretgDCc2AYFFLV00GXDGI= To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/168 X-Sequence-Number: 29778 riakdr@gmail.com ("ria ulfa") writes: > 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.. It's worth observing that the louder the demands are in the subject line, the less likely that people are to *want* to volunteer assistance. The problem here is that COPY accesses data as whatever Unix user is running the database, typically "postgres" or "pgsql". Presumably that user hasn't rights to access the file "/tmp/logfile.txt". Perhaps that needs to be changed. -- select 'cbbrowne' || '@' || 'linuxfinances.info'; http://cbbrowne.com/info/lsf.html Rules of the Evil Overlord #145. "My dungeon cell decor will not feature exposed pipes. While they add to the gloomy atmosphere, they are good conductors of vibrations and a lot of prisoners know Morse code."