> On Fri, 22 Mar 2024, 3:33 pm Laurenz Albe, <laurenz.albe@xxxxxxxxxxx> 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. > > It's almost 8gb, could you explain me how can I transfer as binary file?.I'm new on this. With 8GB, you cannot use "bytea" on PostgreSQL. There is support for PostgreSQL Large Objects with ora2pg; you'd have to read the documentation to find out more. I cannot help you with the memory allocation error, mostly because you didn't tell us what exactly you did to trigger it. Yours, Laurenz Albe
