Re: BUG #16127: PostgreSQL 12.1 on Windows 2008 R2copy table from ‘large 2GB csv’report “Unknown error”

From: sirlipeng <sirlipeng(at)gmail(dot)com>
To: tomas(dot)vondra(at)2ndquadrant(dot)com <tomas(dot)vondra(at)2ndquadrant(dot)com>
Cc: leiyanliang(at)highgo(dot)com <leiyanliang(at)highgo(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #16127: PostgreSQL 12.1 on Windows 2008 R2copy table from ‘large 2GB csv’report “Unknown error”
Date: 2019-11-28 04:15:51
Message-ID: C060FEEF-6169-4E4D-A09D-167796AECC6F@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

<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,&quot;Microsoft Yahei&quot;,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(at)highgo(dot)com wrote:</span></div><div><br style="line-height: 22.4px;"><span style="line-height: 22.4px;">&gt;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;">&gt;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;">&gt;due to using different windows version 2008 R2 vs. 2012 R2, though.</span><br style="line-height: 22.4px;">&gt;<br style="line-height: 22.4px;"><span style="line-height: 22.4px;">&gt;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;">&gt;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;">&gt;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;">&gt;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&nbsp;<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>

Attachment Content-Type Size
unknown_filename text/html 2.3 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message RideNext 2019-11-28 06:53:06 Postgres takes more than 6 minutes to come up during host/standby switch over
Previous Message PG Bug reporting form 2019-11-27 23:00:02 BUG #16140: View with INSERT, DO INSTEAD, and ON CONFLICT causes an error