Postgres Pro
Downloads
Home   >   mailing lists

Thread: Réf. : Re: Out of memory using ora2pg

Réf. : Re: Out of memory using ora2pg

From
Prestation3.EXPLOITATION@nexans.com
Date:
Thanks for the answer...
the configuration is as below:

Oracle          ---->   Ora2pg    ----> PostgreSQL
Windows 2000            Linux           Windows 2000
500 MB                  3 GB            256 MB

Ora2pg.pl  is executed on linux
top gives for porcess ora2pg.pl
VIRT    RES
44272   28m

Thanks for your help ...






Richard Huxton <dev@archonet.com>
22/02/2006 10:24


        Pour :  Prestation3.EXPLOITATION@nexans.com
        cc :    pgsql-general@postgresql.org
        Objet : Re: [GENERAL] Out of memory using ora2pg


Prestation3.EXPLOITATION@nexans.com wrote:
>
> Is it a problem with perl memory or posgresql memory ?
> Can you hellp me please ?

What does "top" show for memory usage of the processes in question?

How much memory do you have in the machine?

--
   Richard Huxton
   Archonet Ltd

Re: Réf. : Re: [GENERAL] Out

From
Richard Huxton
Date:
Prestation3.EXPLOITATION@nexans.com wrote:
> Thanks for the answer...
> the configuration is as below:
>
> Oracle          ---->   Ora2pg    ----> PostgreSQL
> Windows 2000            Linux           Windows 2000
> 500 MB                  3 GB            256 MB
>
> Ora2pg.pl  is executed on linux
> top gives for porcess ora2pg.pl
> VIRT    RES
> 44272   28m

OK, so given your original error message:
"Dumping table TRANSACTIONS...
........................................................DBD::Pg::st
execute failed: ERROR:  out of memory
DETAIL:  Failed on request of size 16."

It looks to me like this is on your Windows box (256MB). This leads us
to two questions:
1. What is that machine showing for its memory usage?
2. What do the logs for PostgreSQL say on that machine?

--
   Richard Huxton
   Archonet Ltd