Re: [HACKERS] "CANNOT EXTEND" -

On Mon, 15 Mar 1999, Bruce Momjian wrote:

> [Charset iso-8859-1 unsupported, filtering to ASCII...]
> > Thanks Bruce.
> > 
> > Do you have any idea what happens with pg_dump when it hits 2GB??? Is it set
> > up to segment the files on linux? If not, I may have hit a brick wall here,
> > and have no way to back this baby up.
> > 
> 
> 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.

Also, I think we could do with having some standard way of dumping and
restoring large objects.

--       Peter T Mount peter@retep.org.uk     Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgresJava PDF Generator: http://www.retep.org.uk/pdf