From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ted Allen <tallen@blackducksoftware.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Troubles dumping a very large table.
Date: Wed, 24 Dec 2008 12:49:56 -0500
Message-ID: <12778.1230140996@sss.pgh.pa.us> (raw)
In-Reply-To: <495271EB.80508@blackducksoftware.com>
References: <495271EB.80508@blackducksoftware.com>
Ted Allen <tallen@blackducksoftware.com> writes:
> during the upgrade. The trouble is, when I dump the largest table,
> which is 1.1 Tb with indexes, I keep getting the following error at the
> same point in the dump.
> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR: invalid string enlargement
> request size 1
> pg_dump: The command was: COPY public.large_table (id, data) TO stdout;
> As you can see, the table is two columns, one column is an integer, and
> the other is bytea. Each cell in the data column can be as large as
> 600mb (we had bigger rows as well but we thought they were the source of
> the trouble and moved them elsewhere to be dealt with separately.)
600mb measured how? I have a feeling the problem is that the value
exceeds 1Gb when converted to text form...
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, tallen@blackducksoftware.com
Subject: Re: Troubles dumping a very large table.
In-Reply-To: <12778.1230140996@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox