My guess is you've only changed those permissions on the directory &
file in question - not all the directories leading up to it:
chmod a+r /home/ms/db/csv/AB.csv
chmod a+x /home/ms/db/csv /home/ms/db /home/ms
Also, since this not really a PostgreSQL problem, you can test this
without PostgreSQL in the loop:
su - postgres
ls -l /home/ms/db/csv/AB.csv
Lee.
Matthew Stanfield writes:
> I'm trying to import tables in psql but am getting a permission denied
> error. I'm using the '\i file' command as I intend to import 100+ tables
> and want to set this up to run overnight (almost 1 GB of data is going in).
>
> My test for this is not working. I have a 'batch' file the contents of
> which are (at the moment) only:
>
> COPY ab FROM '/home/ms/db/csv/AB.csv'
>
> Table 'ab' exists as does the csv file and I am logged in as 'postgres'.
>
> I am getting this error when I run "\i batchfile":
>
> psql:batchfile:1: Error: Copy command, running in backend with effective
> uid 26, could not open file '/home/ms/db/csv/AB.csv' for reading. Errorno =
> permission denied (13).