"Vadim Fedorenko" <junk(at)fromru(dot)com> 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