PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15975
PG Version11.5
OSWindows 10
Opened2019-08-23 21:11:38+00
Reported byJohann Oskarsson

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15975
Logged by:          Johann Oskarsson
Email address:      (redacted)
PostgreSQL version: 11.5
Operating system:   Windows 10

When I try to load a large text file into PostgreSQL 11 on Windows, I get an
"unknown error."  This has been discussed on StackOverflow here:

It turns out that trying to COPY FROM a large textfile, say several
gigabytes, will always fail.  According to Stack Overflow, this only happens
on PostgreSQL 11.  The earlier releases don't seem to have this problem.

Example, given

  create table pwned( passwd sha1 not null, count int4 not null );


  copy pwned( passwd, count ) from
'c:\src\postgres\pwned\pwned-passwords-sha1-ordered-by-hash-v5.txt' with (
format text, delimiter ':' );


  ERROR:  could not stat file
"c:\src\postgres\pwned\pwned-passwords-sha1-ordered-by-hash-v5.txt": Unknown

Workaround is to pipe the file through a program, as discussed here:


2019-08-23 21:11:38+00PG Bug reporting formBUG #15975: Copy from large text files on Windows returns "unknown error"
2019-08-23 21:53:56+00Tom LaneRe: BUG #15975: Copy from large text files on Windows returns "unknown error"