From: sirlipeng <sirlipeng@gmail.com>
To: tomas.vondra@2ndquadrant.com <tomas.vondra@2ndquadrant.com>
Cc: leiyanliang@highgo.com <leiyanliang@highgo.com>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #16127: PostgreSQL 12.1 on Windows 2008 R2copy table from ‘large 2GB csv’report “Unknown error”
Date: Thu, 28 Nov 2019 12:15:51 +0800
Message-ID: <C060FEEF-6169-4E4D-A09D-167796AECC6F@gmail.com> (raw)
In-Reply-To: <20191120161909.edfjorf7rnvrox6q@development>
References: <16127-cd8faadee42e85d5@postgresql.org>
<20191120132159.7xlgs2sl3ggoeiel@development>
<201911202141482799261@highgo.com>
<20191120161909.edfjorf7rnvrox6q@development>
<html>
<head>
<meta http-equiv='Content-Type' content='text/html; charset=UTF-8'>
</head>
<body>
<style>
font{
line-height: 1.6;
}
ul,ol{
padding-left: 20px;
list-style-position: inside;
}
</style>
<div style = 'font-family:微软雅黑,Verdana,"Microsoft Yahei",SimSun,sans-serif;font-size:14px; line-height:1.6;'>
<div ></div><div>
<div><span style="line-height: 22.4px;">On Wed, Nov 20, 2019 at 09:42:49PM +0800, leiyanliang@highgo.com wrote:</span></div><div><br style="line-height: 22.4px;"><span style="line-height: 22.4px;">>In that case, I think Tom is right it's likely the same issue as [1],</span><br style="line-height: 22.4px;"><span style="line-height: 22.4px;">>although that starts with a report about issues with 4GB. Maybe that's</span><br style="line-height: 22.4px;"><span style="line-height: 22.4px;">>due to using different windows version 2008 R2 vs. 2012 R2, though.</span><br style="line-height: 22.4px;">><br style="line-height: 22.4px;"><span style="line-height: 22.4px;">>It'd be good if you could test the latest patch [2] in that thread.</span><br style="line-height: 22.4px;"><span style="line-height: 22.4px;">>You'll need to build PostgreSQL on Windows, though - I don't have much</span><br style="line-height: 22.4px;"><span style="line-height: 22.4px;">>experience with that, but there are wiki pages about doing that either</span><br style="line-height: 22.4px;"><span style="line-height: 22.4px;">>using Visual Studio [3] or mingw [4].</span><br style="line-height: 22.4px;"><br style="line-height: 22.4px;">I have had the same problem on both win2008r2(64bit) and win10(64bit) with postgreSQL12.1.</div><div><br style="line-height: 22.4px;">The problem has been solved when the above path been applied on <span style="line-height: 22.4px;">win2008r2(64bit) and win10(64bit).</span></div></div><div><span style="line-height: 22.4px;"><br></span></div><div>It works:</div><div><div>postgres=# copy github_events from '\\vmware-host\Shared Folders\share\large_eve</div><div>nts.csv' csv;</div><div>COPY 1146625</div></div><div><br></div><div>Best Wishes</div><div>lipeng</div><div>----------------------</div><div>HighGo Software</div><div><br></div><!--😀-->
</div>
</body>
</html>
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: sirlipeng@gmail.com, tomas.vondra@2ndquadrant.com, leiyanliang@highgo.com
Subject: Re: BUG #16127: PostgreSQL 12.1 on Windows 2008 R2copy table from ‘large 2GB csv’report “Unknown error”
In-Reply-To: <C060FEEF-6169-4E4D-A09D-167796AECC6F@gmail.com>
References: <16127-cd8faadee42e85d5@postgresql.org> <20191120132159.7xlgs2sl3ggoeiel@development> <201911202141482799261@highgo.com> <20191120161909.edfjorf7rnvrox6q@development> <C060FEEF-6169-4E4D-A09D-167796AECC6F@gmail.com>
* 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