Re: Fatal Error : Invalid Memory alloc request size 1236252631 - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Fatal Error : Invalid Memory alloc request size 1236252631
Date
Msg-id 6BDA46BE-B926-4BF7-AEBF-C9153D59A51D@a-kretschmer.de
Whole thread Raw
In response to Fatal Error : Invalid Memory alloc request size 1236252631  (Sai Teja <saitejasaichintalapudi@gmail.com>)
List pgsql-general

On 14 August 2023 11:59:26 CEST, Sai Teja <saitejasaichintalapudi@gmail.com> wrote:
>Hi Team,
>
>We are trying to fetch the one row of data (bytea data) for one table in
>But getting the error stating that "Invalid Memory alloc request size
>1236252631"
>
>The row which we were trying to fetch have one bytea column which is more
>than 1GB
>
>Could anyone please help me to resolve this issue.
>

You can try to change the bytea_output. Possible values are hex and escape. With some luck it will work, but maybe your
applicationwill have problems with that. 

Andreas



pgsql-general by date:

Previous
From: Sai Teja
Date:
Subject: Fatal Error : Invalid Memory alloc request size 1236252631
Next
From: Stephen Frost
Date:
Subject: Re: Best strategy to perform individual incremental backups