[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [HACKERS] pg_dump 2GB limit?
From:       Jan Wieck <janwieck () yahoo ! com>
Date:       2002-03-29 19:02:43
[Download RAW message or body]

Christopher Kings-Lynne wrote:
> > > File size limit exceeded (core dumped)
> > >
> > > We suspect pg_dump.  Is this true?  Why would there be this limit in
> > > pg_dump?  Is it scheduled to be fixed?
>
> Try piping the output of pg_dump through bzip2 before writing it to disk.
> Or else, I think that pg_dump has -z or something parameters for turning
> on compression.

    And if that isn't enough, you can pipe the output (compressed
    or not) into split(1).


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
[prev in list] [next in list] [prev in thread] [next in thread]