pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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,&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@highgo.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>

view thread (8+ messages)  latest in thread

Message-ID: <C060FEEF-6169-4E4D-A09D-167796AECC6F@gmail.com>
Permalink:  ../C060FEEF-6169-4E4D-A09D-167796AECC6F@gmail.com/
Also on:    postgresql.org/message-id/C060FEEF-6169-4E4D-A09D-167796AECC6F@gmail.com

 · 

reply

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