COPY command and required file permissions
От | Harold A. Giménez Ch. |
---|---|
Тема | COPY command and required file permissions |
Дата | |
Msg-id | c807ef1a0806120631r7df7800dnb25942ed4ddab740@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: COPY command and required file permissions
Re: COPY command and required file permissions Re: COPY command and required file permissions |
Список | pgsql-sql |
Hi all,<br />In migrating an application from sql server to Postgres, I created a ruby script that extracts csv files fromsql 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. <br /><br />When the scriptruns the COPY commnand, I get the following error (for the genders table):<br /><br />ERROR C42501 M could notopen file "/home/ruby_process/genders.csv" for reading: Permission denied Fcopy.c L1694 RCopyFrom (RuntimeError)<br/><br />My question is, what are the set of permissions required to perform a postgres copy? <br /><br />I'veset the permissions on the directory so that the postgres group owns the directory and has read and execute permissions,as follows:<br /> drwxrwxr-x 3 ruby_process postgres<br /><br />I have also tried moving the files to /tmp andperforming the copy from there, unsuccesfuly.<br /><br />Any ideas would be appreciated. Thanks,<br />-Harold<br /><br/>
В списке pgsql-sql по дате отправления: