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

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