pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #16453: Not able to load a 10gb file.
3+ messages / 3 participants
[nested] [flat]

* BUG #16453: Not able to load a 10gb file.
@ 2020-05-19 13:20 PG Bug reporting form <noreply@postgresql.org>
  2020-05-19 14:14 ` Re: BUG #16453: Not able to load a 10gb file. Daniel Gustafsson <daniel@yesql.se>
  0 siblings, 1 reply; 3+ messages in thread

From: PG Bug reporting form @ 2020-05-19 13:20 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: rishavjainrj1998@gmail.com

The following bug has been logged on the website:

Bug reference:      16453
Logged by:          Rishav Jain
Email address:      rishavjainrj1998@gmail.com
PostgreSQL version: 12.3
Operating system:   Windows 10
Description:        

While loading a 10gb file it is giving unknown error but at the same time a
sample .csv file out of that is working fine what should i do?
Please help its urgent.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: BUG #16453: Not able to load a 10gb file.
  2020-05-19 13:20 BUG #16453: Not able to load a 10gb file. PG Bug reporting form <noreply@postgresql.org>
@ 2020-05-19 14:14 ` Daniel Gustafsson <daniel@yesql.se>
  2020-05-19 14:22   ` Re: BUG #16453: Not able to load a 10gb file. Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Daniel Gustafsson @ 2020-05-19 14:14 UTC (permalink / raw)
  To: rishavjainrj1998@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

> While loading a 10gb file it is giving unknown error but at the same time a
> sample .csv file out of that is working fine what should i do?
> Please help its urgent.

You could start by posting the actual error message you're encountering, the
offending row in the CSV (if possible) and the target table definition.
Without any details on the error there is little anyone can do to help.

It's also quite likely that this isn't a bug in postgres, but an issue with the
data, and if so then pgsql-general@ is a good mailinglist for getting help.

cheers ./daniel




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: BUG #16453: Not able to load a 10gb file.
  2020-05-19 13:20 BUG #16453: Not able to load a 10gb file. PG Bug reporting form <noreply@postgresql.org>
  2020-05-19 14:14 ` Re: BUG #16453: Not able to load a 10gb file. Daniel Gustafsson <daniel@yesql.se>
@ 2020-05-19 14:22   ` Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Juan José Santamaría Flecha @ 2020-05-19 14:22 UTC (permalink / raw)
  To: Daniel Gustafsson <daniel@yesql.se>; +Cc: rishavjainrj1998@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

On Tue, May 19, 2020 at 4:15 PM Daniel Gustafsson <daniel@yesql.se> wrote:

> > While loading a 10gb file it is giving unknown error but at the same
> time a
> > sample .csv file out of that is working fine what should i do?
> > Please help its urgent.
>
> You could start by posting the actual error message you're encountering,
> the
> offending row in the CSV (if possible) and the target table definition.
> Without any details on the error there is little anyone can do to help.
>
> It's also quite likely that this isn't a bug in postgres, but an issue
> with the
> data, and if so then pgsql-general@ is a good mailinglist for getting
> help.
>

The handling of large files in Windows is a known issue [1]. Being an
urgent matter I would recommend you split the file in smaller chunks.

[1] https://commitfest.postgresql.org/28/2189/

Regards,

Juan José Santamaría Flecha

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2020-05-19 14:22 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-05-19 13:20 BUG #16453: Not able to load a 10gb file. PG Bug reporting form <noreply@postgresql.org>
2020-05-19 14:14 ` Daniel Gustafsson <daniel@yesql.se>
2020-05-19 14:22   ` Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>

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