blocks|key|216095|text|chmod+a%2BrX+/users/darchcruise/+/users/darchcruise/desktop+/users/darchcruise/desktop/items_ordered.csv|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|216096|这将更改您的文件夹的访问权限。请注意，每个人都可以读取您的文件。您不能以没有管理权限的用户身份使用chown。还可以考虑学习umask以简化共享文件的创建。|unstyled|offset|length|216097|entityMap|0|LINK|mutability|MUTABLE|url|https://en.wikipedia.org/wiki/Umask^0|0|1Q|5|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|R|8|@]|9|@$G|S|H|T|1|U]]|A|$]]|$1|I|3|-4|5|F|7|V|8|@]|9|@]|A|$]]]|J|$K|$5|L|M|N|A|$O|P]]]]

<pre><code>chmod a+rX /users/darchcruise/ /users/darchcruise/desktop /users/darchcruise/desktop/items_ordered.csv
</code></pre>

This will change access rights for your folder. Note that everyone will be able to read your file.
You can't use chown being a user without administrative rights.
Also consider learning <a href="https://en.wikipedia.org/wiki/Umask" rel="noreferrer">umask</a> to ease creation of shared files.

blocks|key|216133|text|假设使用psql命令行工具，您可以使用\copy而不是copy。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|216134|\copy打开文件并将内容提供给服务器，而copy告诉服务器打开文件本身并读取它，这在权限方面可能是有问题的，如果客户端和服务器运行在不同的机器上，并且之间没有文件共享，甚至是不可能的。|216135|在幕后，\copy被实现为COPY+FROM+stdin，并接受与服务器端COPY相同的选项。|216136|entityMap^0|4|4|J|5|R|4|0|0|5|L|4|0|4|5|D|F|11|4|0^^$0|@$1|2|3|4|5|6|7|L|8|@$9|M|A|N|B|C]|$9|O|A|P|B|C]|$9|Q|A|R|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|S|8|@$9|T|A|U|B|C]|$9|V|A|W|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|X|8|@$9|Y|A|Z|B|C]|$9|10|A|11|B|C]|$9|12|A|13|B|C]]|D|@]|E|$]]|$1|J|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|K|$]]

Assuming the <code>psql</code> command-line tool, you may use <code>\copy</code> instead of <code>copy</code>. 

<code>\copy</code> opens the file and feeds the contents to the server, whereas <code>copy</code> tells the server the open the file itself and read it, which may be problematic permission-wise, or even impossible if client and server run on different machines with no file sharing in-between.

Under the hood, <code>\copy</code> is implemented as <code>COPY FROM stdin</code> and accepts the same options than the server-side <code>COPY</code>.

blocks|key|216251|text|将CSV文件复制到/tmp|type|unstyled|depth|inlineStyleRanges|entityRanges|data|216252|对我来说，这解决了问题。|216253|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Copy the CSV file to /tmp

For me this solved the issue.

blocks|key|216470|text|当我试图将数据从远程服务器导出到本地磁盘时，我遇到了这个问题。我没有意识到SQL+copy实际上是在服务器上执行的，并且它试图写入服务器文件夹。相反，正确的做法是使用\copy，这是psql命令，它会像我预期的那样写入本地文件系统。http://www.postgresql.org/message-id/CAFjNrYsE4Za_KWzmfgN1_-MG7GTw_vpMRxPk=OEjAiLqLskxdA@mail.gmail.com|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|216471|也许这对其他人也有用。|216472|entityMap|0|LINK|mutability|MUTABLE|url|http://www.postgresql.org/message-id/CAFjNrYsE4Za_KWzmfgN1_-MG7GTw_vpMRxPk=OEjAiLqLskxdA@mail.gmail.com^0|15|4|2B|5|38|2V|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]|$9|S|A|T|B|C]]|D|@$9|U|A|V|1|W]]|E|$]]|$1|F|3|G|5|6|7|X|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]]]

I had the issue when I was trying to export data from a remote server into the local disk. I hadn't realised that SQL <code>copy</code> actually is executed on the server and that it tries to write to a server folder. Instead the correct thing to do was to use <code>\copy</code> which is the psql command and it writes to the local file system as I expected. <a href="http://www.postgresql.org/message-id/CAFjNrYsE4Za_KWzmfgN1_-MG7GTw_vpMRxPk=OEjAiLqLskxdA@mail.gmail.com" rel="noreferrer">http://www.postgresql.org/message-id/CAFjNrYsE4Za_KWzmfgN1_-MG7GTw_vpMRxPk=OEjAiLqLskxdA@mail.gmail.com</a>

Perhaps that might be useful to someone else too.

blocks|key|216364|text|另一种方法是，如果你有pgAdmin并且喜欢使用图形用户界面，那就去模式中的表，右击你想要导入文件的表并选择“导入”，浏览你的计算机找到文件，选择你的文件的类型，你想要输入数据的列，然后选择导入。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|216365|这是使用pgAdmin+III和PostgreSQL的9.4版本完成的|216366|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Another way to do this, if you have pgAdmin and are comfortable using the GUI is to go the table in the schema and right click on the table you wish to import the file to and select "Import" browse your computer for the file, select the type your file is, the columns you want the data to be imputed into, and then select import.

That was done using pgAdmin III and the 9.4 version of PostgreSQL

blocks|key|216617|text|我在父文件夹上使用递归chown解决了同样的问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|216618|sudo+chown+-R+postgres:postgres+/home/my_user/export_folder|code-block|syntax|javascript|216619|(我的出口是/home/my_user/export_folder/export_1.csv格式)|offset|length|style|CODE|216620|entityMap^0|0|0|6|14|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

I resolved the same issue with a recursive chown on the parent folder:

<pre><code>sudo chown -R postgres:postgres /home/my_user/export_folder
</code></pre>

(my export being in <code>/home/my_user/export_folder/export_1.csv</code>)

blocks|key|216548|text|对我来说，只需为chown命令添加sudo+(或以root身份运行)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|216549|sudo+chown+postgres+/users/darchcruise/desktop/items_ordered.csv|216550|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

For me it worked to simply to add sudo (or run as root) for the chown command:

sudo chown postgres /users/darchcruise/desktop/items_ordered.csv

blocks|key|216737|text|如果您在Windows10下遇到此问题，请在安全选项卡上添加用户组"youcomputer\+users“并授予其完全控制权，这就解决了我的问题|type|unstyled|depth|inlineStyleRanges|entityRanges|data|216738|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

just in case you're facing this problem under windows 10 , add the group of users "youcomputer\Users" on the security Tab and grant it full control , that solved my issue

blocks|key|216805|text|对于macbook，我首先打开终端，然后输入|type|unstyled|depth|inlineStyleRanges|entityRanges|data|216806|open+/tmp|code-block|syntax|javascript|216807|或者在finder目录中直接输入command%2Bshift%2Bg，然后在go+to+the+folder中键入/tmp。|216808|它会在finder中打开temp文件夹。然后，我再次将复制的csv文件粘贴到此folder.then中。我转到postgres终端，键入以下命令，然后将csv数据复制到db表中。|216809|\copy+recharge_operator+FROM+'/private/tmp/operator.csv'+DELIMITER+','+CSV;|216810|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|S|8|@]|9|@]|A|$E|F]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

for macbook first i opened terminal then type

<pre><code>open /tmp
</code></pre>

or in finder directory you directly enter command+shift+g then type /tmp in go to the folder.

it opens temp folder in finder. then i paste copied csv file into this folder.then again i go to postgres terminal and typed below command and then it is copied my csv data into db table

<pre><code>\copy recharge_operator FROM '/private/tmp/operator.csv' DELIMITER ',' CSV;
</code></pre>

blocks|key|217002|text|COPY+your+table+(Name,+Latitude,+Longitude)+FROM+'C:\Temp\your+file.csv'+DELIMITERS+','+CSV+HEADER;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|217003|使用c:\Temp\"Your+File"\。|unstyled|offset|length|style|CODE|217004|entityMap^0|0|2|K|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|N|8|@$G|O|H|P|I|J]]|9|@]|A|$]]|$1|K|3|-4|5|F|7|Q|8|@]|9|@]|A|$]]]|L|$]]

<pre><code>COPY your table (Name, Latitude, Longitude) FROM 'C:\Temp\your file.csv' DELIMITERS ',' CSV HEADER;
</code></pre>

Use <code>c:\Temp\"Your File"\</code>.

blocks|key|216876|text|我有相同的错误信息，但是我正在使用psycopg2与PostgreSQL通信。我通过使用函数copy_from和copy_expert修复了权限问题，这两个函数将以运行python脚本的用户身份在客户端打开文件，并通过STDIN将数据提供给数据库。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|216877|有关更多信息，请参阅this+link。|216878|entityMap|0|LINK|mutability|MUTABLE|url|http://initd.org/psycopg/docs/cursor.html#cursor.copy_from^0|H|8|1A|9|1K|B|31|5|0|A|9|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]|$9|S|A|T|B|C]|$9|U|A|V|B|C]|$9|W|A|X|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Y|8|@]|D|@$9|Z|A|10|1|11]]|E|$]]|$1|H|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]]]

I had the same error message but was using <code>psycopg2</code> to communicate with PostgreSQL. I fixed the permission issues by using the functions <code>copy_from</code> and <code>copy_expert</code> that will open the file on the client side as the user running the python script and feed the data to the database over <code>STDIN</code>.

Refer to <a href="http://initd.org/psycopg/docs/cursor.html#cursor.copy_from" rel="nofollow noreferrer">this link</a> for further information.

blocks|key|216946|text|如果您使用的不是postgres+superuser，则必须向用户授予pg_read_server_files权限。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|216947|示例：|216948|GRANT+pg_read_server_files+TO+my_user+WITH+ADMIN+OPTION;|code-block|syntax|javascript|216949|entityMap^0|8|8|H|9|Z|K|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]|$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|V|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|W|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|X|8|@]|D|@]|E|$]]]|N|$]]

You must grant the <code>pg_read_server_files</code> permission to the user if you are not using <code>postgres</code> <code>superuser</code>.

Example:

<pre><code>GRANT pg_read_server_files TO my_user WITH ADMIN OPTION;
</code></pre>

blocks|key|14|text|我只是将源csv文件复制到外部USB驱动器，它工作正常。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|15|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I just copied the source csv file to an external USB drive, and it worked fine.

blocks|key|216184|text|可能你正在通过连接远程主机来使用pgadmin，然后你试图从你的系统更新，但它在远程系统的文件系统中搜索该文件...这就是我所面对的错误，可能也是为了你去检查它|type|unstyled|depth|inlineStyleRanges|entityRanges|data|216185|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

May be You are using pgadmin by connecting remote host then U are trying to update there from your system but it searches for that file in remote system's file system... its the error wat I faced May be its also for u check it

Computer: Mac OS X, version 10.8
Database: Postgres

Trying to import csv file into postgres.

<pre><code>pg&gt; copy items_ordered from '/users/darchcruise/desktop/items_ordered.csv' with CSV;
ERROR: could not open file "/users/darchcruise/desktop/items_ordered.csv" for reading: Permission denied
</code></pre>

Then I tried

<pre><code>$&gt; chown postgres /users/darchcruise/desktop/items_ordered.csv
chown: /users/darchcruise/desktop/items_ordered.csv: Operation not permitted
</code></pre>

Lastly, I tried

<pre><code>$&gt; ls -l
-rw-r--r-- 1 darchcruise staff 1016 Oct 18 21:04 items_ordered.csv
</code></pre>

Any help is much appreciated!

Postgres ERROR: could not open file for reading: Permission denied

命令行工具

文件系统

PostgreSQL

数据库

服务器

计算机: Mac OS X，版本10.8数据库: Postgres正在尝试将csv文件导入postgres。pg> copy items_ordered from '/users/darchcruise/desktop/items_ordered.csv' with CSV;ERROR:  could not open file "/users/darchcruise/desktop/items_

问Postgres错误:无法打开文件进行读取:权限被拒绝
EN

回答 14

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Postgres错误:无法打开文件进行读取:权限被拒绝EN

回答 14

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Postgres错误:无法打开文件进行读取:权限被拒绝
EN