Re: pg_dump out of memory

On 07/03/2018 10:21 PM, Adrian Klaver wrote:
> On 07/03/2018 07:43 PM, Andy Colson wrote:
>> Hi All,
>>
>> I moved a physical box to a VM, and set its memory to 1Gig.  Everything
>> runs fine except one backup:
>>
>>
>> /pub/backup# pg_dump -Fc -U postgres -f wildfire.backup wildfirep
>>
>> g_dump: Dumping the contents of table "ofrrds" failed: PQgetResult() failed.
>> pg_dump: Error message from server: ERROR:  out of memory
>> DETAIL:  Failed on request of size 1073741823.
>> pg_dump: The command was: COPY public.ofrrds (id, updateddate, bytes) TO
>> stdout;
>>
>>
>>
>> I'm not sure how to get this backup to run.  Any hints would be appreciated.
>
> Maybe:
>
> 1) Try:
>     pg_dump -t ofrrds
>    to dump only that table.
>

It didnt work. I get the same error.

Also, I'm running Slackware 14.2, and PG 9.5.11

-Andy