pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: leiyanliang@highgo.com
Subject:  BUG #16127: PostgreSQL 12.1 on Windows 2008 R2 copy table from ‘large 2GB csv’report “Unknown error”
Date: Wed, 20 Nov 2019 12:42:38 +0000
Message-ID: <16127-cd8faadee42e85d5@postgresql.org> (raw)

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!!!
时间: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.



view thread (8+ messages)  latest in thread

Message-ID: <16127-cd8faadee42e85d5@postgresql.org>
Permalink:  ../16127-cd8faadee42e85d5@postgresql.org/
Also on:    postgresql.org/message-id/16127-cd8faadee42e85d5@postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-bugs@postgresql.org
  Cc: noreply@postgresql.org, leiyanliang@highgo.com
  Subject: Re: BUG #16127: PostgreSQL 12.1 on Windows 2008 R2 copy table from ‘large 2GB csv’report “Unknown error”
  In-Reply-To: <16127-cd8faadee42e85d5@postgresql.org>
  References: <16127-cd8faadee42e85d5@postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox