On Wed, Jul 07, 2004 at 04:28:53PM +0100, Hilary Forbes wrote: >
> ... when I run pg_dump to restore the data, one table with approx
> 5.5 million records gives me
>
> ERROR: invalid memory alloc request size 1073741824
What do you mean "pg_dump to restore the data"? One would normally use
psql or pg_restore to actually "restore" the data.
In the past, that error message indicated some corrupted data that
prevents a reading one or more rows in a table (and therefore prevents
a pg_dump). But you seem to be saying that you can regularly dump that
table without any problems.
When can you dump the table? And when can you not dump the table?
-Mike