| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Prestation3(dot)EXPLOITATION(at)nexans(dot)com |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Réf. : Re: [GENERAL] Out |
| Date: | 2006-02-22 13:04:58 |
| Message-ID: | 43FC617A.4040804@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Prestation3(dot)EXPLOITATION(at)nexans(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | fritz-bayer@web.de | 2006-02-22 13:26:15 | setting LC_NUMERIC |
| Previous Message | Prestation3.EXPLOITATION | 2006-02-22 12:03:46 | Réf. : Re: Out of memory using ora2pg |