Re: BUG #16127: PostgreSQL 12.1 on Windows 2008 R2 copy table from ‘large 2GB csv’report “Unknown error”
От | Tomas Vondra |
---|---|
Тема | Re: BUG #16127: PostgreSQL 12.1 on Windows 2008 R2 copy table from ‘large 2GB csv’report “Unknown error” |
Дата | |
Msg-id | 20191120132159.7xlgs2sl3ggoeiel@development обсуждение исходный текст |
Ответ на | BUG #16127: PostgreSQL 12.1 on Windows 2008 R2 copy table from ‘large 2GB csv’report “iso-8859-1 error” (PG Bug reporting form <noreply@postgresql.org>) |
Список | pgsql-bugs |
On Wed, Nov 20, 2019 at 12:42:38PM +0000, PG Bug reporting form wrote: >The following bug has been logged on the website: > >Bug reference: 16127 >Logged by: yanliang lei >Email address: leiyanliang@highgo.com >PostgreSQL version: 12.1 >Operating system: Windows 2008 R2 >Description: > >D:\>dir > 驱动器 D 中的卷是 新加卷 > >D:\Program Files\PostgreSQL\12>cd bin > >D:\Program Files\PostgreSQL\12\bin>psql -d postgres -U posgres >用户 posgres 的口令: >psql: 错误: 无法连接到服务器:FATAL: password authentication failed for user "p >osgres" > >D:\Program Files\PostgreSQL\12\bin>psql -d postgres -U postgres >用户 postgres 的口令: >psql (12.1) >输入 "help" 来获取帮助信息. > >postgres=# select version(); > version >------------------------------------------------------------ > PostgreSQL 12.1, compiled by Visual C++ build 1914, 64-bit >(1 行记录) > > >postgres=# CREATE TABLE github_events >postgres-# ( >postgres(# event_id bigint, >postgres(# event_type text, >postgres(# event_public boolean, >postgres(# repo_id bigint, >postgres(# payload jsonb, >postgres(# repo jsonb, >postgres(# user_id bigint, >postgres(# org jsonb, >postgres(# created_at timestamp >postgres(# ); >CREATE TABLE >postgres=# \timing >启用计时功能. >postgres=# set client_encoding='UTF8'; >SET >时间:1.185 ms >postgres=# set lc_messages=en_us; >SET >时间:23.467 ms >postgres=# copy github_events from 'd:\large_events.csv' csv; >ERROR: could not stat file "d:\large_events.csv": Unknown error >----->>>Please note this error!!! This probably means the PostgreSQL user/process does not have access to the file, either because it does not exist, lack of privileges, an AV system blocking the access, or something like that. I suggest you seach in the Windows Event Log, and various other logs you might have there. regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
В списке pgsql-bugs по дате отправления: