BUG #16453: Not able to load a 10gb file.

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

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]https://commitfest.postgresql.org/28/2189/. 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