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
