From: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> |
---|---|
To: | leiyanliang(at)highgo(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #16127: PostgreSQL 12.1 on Windows 2008 R2 copy table from ‘large 2GB csv’report “Unknown error” |
Date: | 2019-11-20 13:21:59 |
Message-ID: | 20191120132159.7xlgs2sl3ggoeiel@development |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)highgo(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | leiyanliang@highgo.com | 2019-11-20 13:42:49 | Re: Re: BUG #16127: PostgreSQL 12.1 on Windows 2008 R2copy table from ‘large 2GB csv’report “Unknown error” |
Previous Message | PG Bug reporting form | 2019-11-20 12:42:38 | BUG #16127: PostgreSQL 12.1 on Windows 2008 R2 copy table from ‘large 2GB csv’report “Unknown error” |