Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 3ED9F9FB52A for ; Tue, 15 May 2007 07:50:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 68447-06 for ; Tue, 15 May 2007 07:50:49 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail1.sun.ac.za (mail1.sun.ac.za [146.232.64.12]) by postgresql.org (Postfix) with ESMTP id 990CC9FB4C5 for ; Tue, 15 May 2007 07:50:47 -0300 (ADT) Received: from burger.sun.ac.za ([146.232.128.30]) by mail1.sun.ac.za with esmtp (Exim 4.50) id 1Hnuc6-0003Z4-52 for pgsql-admin@postgresql.org; Tue, 15 May 2007 12:50:42 +0200 Received: from js by burger.sun.ac.za with local (Exim 4.63) (envelope-from ) id 1Hnuc6-00028g-3a for pgsql-admin@postgresql.org; Tue, 15 May 2007 12:50:42 +0200 Date: Tue, 15 May 2007 12:50:42 +0200 From: Johann Spies To: pgsql-admin@postgresql.org Subject: Re: ERROR: invalid memory alloc request size Message-ID: <20070515105042.GA8121@burger.sun.ac.za> References: <20070514131318.GA26537@sun.ac.za> <11217.1179153258@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <11217.1179153258@sss.pgh.pa.us> User-Agent: mutt-ng/devel-r804 (Debian) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/116 X-Sequence-Number: 25436 * Tom Lane [070514 16:36]: > > If Postgres was built with debug symbols it would be useful to get a > stack trace to try to figure out more about what's happening. If you > want to try that, attach to the backend with gdb while the COPY is > running, then do > > $ gdb /path/to/postgres PID-of-backend Which pg-process? The Postmaster or psql? I have done this for the Postmaster now but > gdb> b errfinish > gdb> cont > ... wait for breakpoint to be hit ... This did not happen although the error occurred (after a few hours). Regards Johann -- Johann Spies Telefoon: 021-808 4036 Informasietegnologie, Universiteit van Stellenbosch "Let not your heart be troubled: ye believe in God, believe also in me." John 14:1