Re: pg_restore out of memory - Mailing list pgsql-general

Alvaro Herrera writes:

> Can you send the program along?  And the table definition (including
> indexes, etc)?

I put the table definition and a Python program that reproduces the problem
at:

http://public.natserv.net/table-schema.sql
http://public.natserv.net/large_record.py

The program uses the psycopg2 library.
All the program does is to send test data to the table, in particular doing
a large text size for a text column called attachment_body.

The database doesn't give an out of error message like when trying to run a
copy, but instead generates a lot output to the log such as
http://public.natserv.net/postgresql-2007-06-19.txt

The out of memory error when trying to use the copy command is
http://public.natserv.net/postgresql-2007-06-15.log

Thanks for any further pointers and suggestions.
Don't know what else to try at this point.