Re: Fatal Error : Invalid Memory alloc request size 1236252631

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org, Sai Teja <saitejasaichintalapudi(at)gmail(dot)com>
Subject: Re: Fatal Error : Invalid Memory alloc request size 1236252631
Date: 2023-08-14 11:42:20
Message-ID: 6BDA46BE-B926-4BF7-AEBF-C9153D59A51D@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 14 August 2023 11:59:26 CEST, Sai Teja <saitejasaichintalapudi(at)gmail(dot)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 application will have problems with that.

Andreas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2023-08-14 12:58:59 Re: Best strategy to perform individual incremental backups
Previous Message Sai Teja 2023-08-14 09:59:26 Fatal Error : Invalid Memory alloc request size 1236252631