Re: pg_dump and large files - is this a problem?

Tom Lane wrote:
> Philip Warner <pjw(at)rhyme(dot)com(dot)au> writes:
> > Is it my imagination, or is there a problem with the way pg_dump uses off_t
> > etc. My understanding is that off_t may be 64 bits on systems with 32 bit
> > ints. But it looks like pg_dump writes them as 4 byte values in all cases.
> > It also reads them as 4 byte values. Does this seem like a problem to
> > anybody else?
>
> Yes, it does --- the implication is that the custom format, at least,
> can't support dumps > 4Gb. What exactly is pg_dump writing off_t's
> into files for; maybe there's not really a problem?
>
> If there is a problem, seems like we'd better fix it. Perhaps there
> needs to be something in the header to tell the reader the sizeof
> off_t.

BSD/OS has 64-bit off_t's so it does support large files. Is there
something I can test?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073