"Vadim Fedorenko" <[email protected]> writes:
> I have a database about 4Gb and pg_dump fails with
> ERROR: out of memory
> DETAIL: Failed on request of size 536870912.
> I found out that it fails on selecting bug bytea field:
Huh, how did you get that value into the table in the first place?
> how can I workaround this?
Increase the memory limit the postmaster runs under. If it's
a 32-bit machine, you might need to decrease shared_buffers
so there's more address space available as workspace.
regards, tom lane
--
Sent via pgsql-bugs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
