Re: [HACKERS] "CANNOT EXTEND" -

> > 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