Re: Out of memory using ora2pg - Mailing list pgsql-general

From Tom Lane
Subject Re: Out of memory using ora2pg
Date
Msg-id 11616.1140620310@sss.pgh.pa.us
Whole thread Raw
In response to Out of memory using ora2pg  (Prestation3.EXPLOITATION@nexans.com)
List pgsql-general
Prestation3.EXPLOITATION@nexans.com writes:
> Dumping table TRANSACTIONS...
> ........................................................DBD::Pg::st
> execute failed: ERROR:  out of memory
> DETAIL:  Failed on request of size 16.
> ERROR:  out of memory
> DETAIL:  Failed on request of size 16.

> Is it a problem with perl memory or posgresql memory ?

Given the spelling of the error message, that's coming from the server
side (I don't think we have any client-side code that uses DETAIL lines).
What is the exact SQL query that's being executed here?  (If you don't
know, try enabling query logging in the server so you can find out.)
You should be able to replicate the failure by entering the same query
via psql.  If so, let's see the output of EXPLAIN for the query.

            regards, tom lane

pgsql-general by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Attn. PostgreSQL.org webmasters: Site Link not working
Next
From: jason.ctr.alburger@faa.gov
Date:
Subject: ecpg error --> DbPg_cre_sect_buf.pgc:1334: ERROR: syntax error at or near "RELEASE"