On 09/10/2010, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> e-letter <inpost@gmail.com> writes:
>> The following command was entered from normal user account where csv files
>> are:
>
>> COPY newdatabasenametable FROM '/path/to/file.csv' WITH CSV;
>> ERROR: could not open file "/path/to/file.csv" for reading: Permission
>> denied
>
> The postgres account either doesn't have permission to read that file,
> or doesn't have permission to search one of the directories in the path.
>
Using the command:
ls -ao file.csv
showed:
-rwxr-xr-x
This suggests to me that 'others' have permission to search the
directory for the file.
>> su root
>> su postgres
>> psql newdatabasename
>> could not change directory to "/path/to
>
> This would work better with "su -l postgres", so that you don't end
> up with a situation where psql is being started in a directory it
> has no permissions for.
>
Please advise documentation that explains the '-l' command. I tried
'man su' but no terminal response.
