Re: Ora2pg migration

I can't help asking: what in the heck are you storing that's *eight
gigabytes*???

On Mon, Mar 25, 2024 at 2:33 PM Narendran .j <jnarendran3(at)gmail(dot)com> wrote:

> Hello
> It's almost 8gb, could you explain me how can I transfer as
> binary file?.I'm new on this.
>
> On Fri, 22 Mar 2024, 3:33 pm Laurenz Albe, <laurenz(dot)albe(at)cybertec(dot)at>
> wrote:
>
>> On Fri, 2024-03-22 at 11:08 +0530, Narendran .j wrote:
>> > I have export one table which has blob data type by ora2pg tool.while
>> Importing insert file in postgres I'm getting this error .
>> > psql:ERROR: out of memory
>> > DETAIL: Cannot enlarge string buffer containing 1073741808 bytes by
>> 8191 more bytes.
>> >
>> > Please give me any suggestions and I adjust shared_buffer it didn't
>> work.
>>
>> 1GB is a hard limit for memory allocations.
>>
>> How big are those BLOBs? The theoretical limit in PostgreSQL is 1GB, but
>> in
>> practice things start getting difficult around 500MB, unless you use
>> binary
>> transfer.
>>
>> Yours,
>> Laurenz Albe
>>
>