"beer" <beer@cmu.edu> writes:
> We have a medium sized database that when dumped creates +4G files
> within the tar archive. When we restore it seems that pg_restore has
> a 4G limit for reading files, once it reads 4G of a file, it moves on
> to the next file. Has anyone else experienced this problem?

There is a member size limit inherent to the tar-archive code, although
I thought it was 8G not 4G. I'd recommend using custom format (-Fc not
-Ft).

Still, if the thing is truncating your data and not telling you so,
that'd qualify as a bug.

On some platforms there might be a problem with lack of large-file
support at the stdio level, too. What is your platform?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend