From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Narendran .j <jnarendran3@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Ora2pg migration
Date: Mon, 25 Mar 2024 16:30:12 +0100
Message-ID: <ed18136f6cecf67e4cb414395aa56356b5b82b47.camel@cybertec.at> (raw)
In-Reply-To: <CA+-Cqf5fu8p=CWXv80-s5AuVJ-ntfgLjSfW1iYo9YGU5uN-XTg@mail.gmail.com>
References: <CA+-Cqf63n5MOo-L9gue5ZGMWLd9jXrdvGV4nV7-KbspyKhnd7A@mail.gmail.com>
<353421c01d9645555244d41fc111304dcf66d051.camel@cybertec.at>
<CA+-Cqf5fu8p=CWXv80-s5AuVJ-ntfgLjSfW1iYo9YGU5uN-XTg@mail.gmail.com>
> On Fri, 22 Mar 2024, 3:33 pm Laurenz Albe, <laurenz.albe@cybertec.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.
>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, jnarendran3@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Ora2pg migration
In-Reply-To: <ed18136f6cecf67e4cb414395aa56356b5b82b47.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox