"Chris Hopkins" <chopkins@xxxxxxx> writes: > 2009-08-19 22:35:42 ERROR: out of memory > 2009-08-19 22:35:42 DETAIL: Failed on request of size 536870912. > Is there an easy way to give pg_dump more memory? That isn't pg_dump that's out of memory --- it's a backend-side message. Unless you've got extremely wide fields in this table, I would bet on this really being a corrupted-data situation --- that is, there's some datum in the table whose length word has been corrupted into a very large value. You can try to isolate and delete the corrupted row(s). regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
