From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | leiyanliang(at)highgo(dot)com |
Subject: | BUG #16127: PostgreSQL 12.1 on Windows 2008 R2 copy table from ‘large 2GB csv’report “Unknown error” |
Date: | 2019-11-20 12:42:38 |
Message-ID: | 16127-cd8faadee42e85d5@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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!!!
时间:4.558 ms
postgres=# select version();
version
------------------------------------------------------------
PostgreSQL 12.1, compiled by Visual C++ build 1914, 64-bit
----->>>>PostgreSQL version is 12.1
(1 行记录)
时间:0.280 ms
postgres=#
Please note:
1. d:\large_events.csv this file is large 2GB。
2. the software “postgresql-12.1-1-windows-x64.exe” is downloaded from
enterprisedb website.
From | Date | Subject | |
---|---|---|---|
Next Message | Tomas Vondra | 2019-11-20 13:21:59 | Re: BUG #16127: PostgreSQL 12.1 on Windows 2008 R2 copy table from ‘large 2GB csv’report “Unknown error” |
Previous Message | Manuel Rigger | 2019-11-20 12:42:30 | ALTER TABLE fails when changing column type due to index with bit_ops opclass |