> > pg_dump only dumps a flat unix file. That can be any size your OS
> > supports. It does not segment. However, a 2gig table will dump to a
> > much smaller version than 2gig because of the overhead for every record.
>
> Hmmm, I think that, as some people are now using >2Gig tables, we should
> think of adding segmentation to pg_dump as an option, otherwise this is
> going to become a real issue at some point.
So the OS doesn't get a table over 2 gigs. Does anyone have a table
that dumps a flat file over 2gig's, whose OS can't support files over 2
gigs. Never heard of a complaint.
>
> Also, I think we could do with having some standard way of dumping and
> restoring large objects.
I need to add a separate large object type.
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026