From: | Alistair Johnson <alistair(dot)e(dot)w(dot)j(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Unable to copy large (>2GB) files using PostgreSQL 11 (Windows) |
Date: | 2018-11-02 18:46:44 |
Message-ID: | CAKHmqNCfTMM6=Pqc6RUMEQ_2BPfo5KGGG-0fzRXZCVooo=wdNA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | Postg윈 토토SQL : Postg윈 토토SQL 메일 링리스트 : 2018-11-02 이후 PGSQL-BUGS 18:46 |
Hello,
I am unable to use psql's \COPY command to load in large text files on
Windows. Here are the steps I used to reproduce:
1. Install PostgreSQL 11.0 from enterprisedb
2. Create two files: test1.txt (2.4 GB) and test2.txt (1.8 GB) - content
doesn't matter
3. Run SQL Shell (psql)
postgres=# create table tbl (col int);
CREATE TABLE
postgres=# \COPY tbl FROM 'test1.txt'
could not stat file "test1.txt": Unknown error
postgres=# \COPY tbl from 'test2.txt'
(runs normally)
I believe the issue is related to `stat` not handling large files properly.
I installed PostgreSQL 10.5 Windows x86-64 from the EDB website, attempted
to reproduce, and *could not* reproduce the error, so I think this is a
PostgreSQL 11 specific bug.
-Alistair
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Munro | 2018-11-02 22:11:31 | Re: BUG #15475: Views over CITEXT columns return no data |
Previous Message | Magnus Hagander | 2018-11-02 18:15:32 | Re: pgstattuple does not work with uppercase table names |