DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	b=oIffW4ne3W5t4e0Mtki20MzkfTv8JgPW0dn/xZn+Q+7032Rqh/kMt62aNkos3YNd/9
	mOBLvB8fHb4ZZDtYyc+sCI//9W7697jhgwMz30NjEzdXMsNSW9KQSmBojNeC5eiZKHrt
	cDCjiIRygyiCOBu9Uk4cNnEmgS5BE+FnjqLXk=
Message-ID: <4C24F765.40008@gmail.com>
Date: Fri, 25 Jun 2010 11:37:25 -0700
From: Adrian Klaver <adrian.klaver@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.1.10) Gecko/20100512 Thunderbird/3.0.5
MIME-Version: 1.0
To: "bruno.scovoli" <bruno.scovoli@gmail.com>
CC: pgsql-sql@postgresql.org
Subject: Re: COPY command and required file permissions
References: <c807ef1a0806120631r7df7800dnb25942ed4ddab740@mail.gmail.com>
	<28976565.post@talk.nabble.com>
In-Reply-To: <28976565.post@talk.nabble.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

On 06/23/2010 02:01 PM, bruno.scovoli wrote:
>
> I have an script with many "\copy" commands. For example:
>
> \copy privilegios from '/work/eclipse-workspace/Canoan
> Server/database/load/privilegios.dat'
> \copy privilegios_de_usuarios from '/work/eclipse-workspace/Canoan
> Server/database/load/privilegios_de_usuarios.dat'
> \copy classificacoes from '/work/eclipse-workspace/Canoan
> Server/database/load/classificacoes.dat'
> \copy tipo_de_produto from '/work/eclipse-workspace/Canoan
> Server/database/load/tipos.dat'
>
> This lines are OK. But when I remove the preceding backslash from them I get
> the error that you mentioned.
>
>
> Harold A. Giménez Ch. wrote:
>>
>> Hi all,
>> In migrating an application from sql server to Postgres, I created a ruby
>> script that extracts csv files from sql server (from a windows box), then
>> SCPs them into a directory (/home/ruby_process) on the server running
>> Postgres (a Fedora core 8) and finally runs the Postgres COPY command for
>> each of the csv files.
>>
>> When the script runs the COPY commnand, I get the following error (for the
>> genders table):
>>
>> ERROR    C42501  M could not open file "/home/ruby_process/genders.csv"
>> for
>> reading: Permission denied     Fcopy.c L1694   RCopyFrom (RuntimeError)
>>
>> My question is, what are the set of permissions required to perform a
>> postgres copy?
>>
>> I've set the permissions on the directory so that the postgres group owns
>> the directory and has read and execute permissions, as follows:
>> drwxrwxr-x 3 ruby_process postgres
>>
>> I have also tried moving the files to /tmp and performing the copy from
>> there, unsuccesfuly.
>>
>> Any ideas would be appreciated. Thanks,
>> -Harold
>>
>>
>

Are you connecting to the database as a superuser to run the COPY command?

-- 
Adrian Klaver
adrian.klaver@gmail.com