Réf. : Re: Out of memory using ora2pg
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
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 MBOra2pg.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