Re: Unable to copy large (>2GB) files using PostgreSQL 11 (Windows)

On Fri, Nov 02, 2018 at 02:46:44PM -0400, Alistair Johnson wrote:
> 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.

You would be interested in this thread then:
https://www.postgresql.org/message-id/1803D792815FC24D871C00D17AE95905CF5099@g01jpexmbkw24

Windows portability problems with stat() makes this problem way harder
than it looks at first glance, because it also uses a "stat" structure
which is not able to store the size of files larger than 2GB.  I tried a
couple of solutions for that, but gave up because of how things got
easily dirty.  I don't think that we want to replace the "stat"
structure used all over the code for a "pg_stat" equivalent either, many
folks rely on the system definitions for many patches, so that would be
most likely forgotten and lead to extra bugs on Windows :(

If somebody is smart enough to design a patch for that one, please feel
free to send one..
--
Michael