Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #13446: pg_dump fails with large tuples - Mailing list pgsql-bugs

From jaime soler
Subject Re: BUG #13446: pg_dump fails with large tuples
Date
Msg-id 1434534046.3638.31.camel@gmail.com
Whole thread Raw
In response to Re: BUG #13446: pg_dump fails with large tuples  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-bugs
Tree view 
El mié, 17-06-2015 a las 13:08 +0900, Michael Paquier escribió:
> On Tue, Jun 16, 2015 at 8:20 PM,  <cpt@novozymes.com> wrote:
> > This message then shows up in the server logs.  It looks like maybe pg_dump
> > is limited to exactly 1GB textual representation?
>
> Yep. That's a known limitation of COPY and palloc() in general.

But could we use pg_dump with -Fc or -Fd in this case ?  or the only way
to backup this table is using physical backup ?

Thanks
> --
> Michael
>
>

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #13446: pg_dump fails with large tuples
Next
From: Christoph Berg
Date:
Subject: Re: [GENERAL] pg_xlog on a hot_standby slave filling up