Re: pg_dump and large files - is this a problem? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: pg_dump and large files - is this a problem?
Date
Msg-id 200210011520.g91FKif18276@candle.pha.pa.us
Whole thread Raw
In response to Re: pg_dump and large files - is this a problem?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_dump and large files - is this a problem?  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-hackers
Tom Lane wrote:
> Philip Warner <pjw@rhyme.com.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@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: 7.2.3 patching done
Next
From: "Tim Knowles"
Date:
Subject: Re: Postgresql likes Tuesday...