Error in COPY command with files over 1GB

From: Andrew Zimmerman <andrew(at)abcsoftek(dot)com>
To: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Error in COPY command with files over 1GB
Date: 2019-08-08 16:30:00
Message-ID: BN8PR04MB6033B0CB582CA6FBDCCA6EA2DED70@BN8PR04MB6033.namprd04.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I am getting the following error when importing from a tab-delimited text file longer than 1 GB.
ERROR: could not stat file "C:\ABC Software\Database Export\Data\invoice_detail.data": Unknown error
Splitting the tab-delimited file into multiple files less than 1 GB and COPY'ing them individually works correctly.
I tested on both versions 11.2 and 11.4 on Windows with the same result.

Andrew Zimmerman
ABC Softek LLC
andrew(at)abcsoftek(dot)com<mailto:andrew(at)abcsoftek(dot)com>
www.SimplifyMyBiz.com<http://www.simplifymybiz.com/>

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2019-08-08 16:43:32 Re: BUG #15943: Valgrind-detected error in SlruPhysicalWritePage
Previous Message Alexander Lakhin 2019-08-08 13:33:33 Re: BUG #15943: Valgrind-detected error in SlruPhysicalWritePage