Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id DF1949FBCD8 for ; Wed, 16 May 2007 14:50:13 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 64096-01 for ; Wed, 16 May 2007 14:49:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 13EA69FBCF5 for ; Wed, 16 May 2007 14:50:05 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l4GHo4ht005222; Wed, 16 May 2007 13:50:04 -0400 (EDT) To: Johann Spies cc: pgsql-admin@postgresql.org Subject: Re: ERROR: invalid memory alloc request size In-reply-to: <20070515105042.GA8121@burger.sun.ac.za> References: <20070514131318.GA26537@sun.ac.za> <11217.1179153258@sss.pgh.pa.us> <20070515105042.GA8121@burger.sun.ac.za> Comments: In-reply-to Johann Spies message dated "Tue, 15 May 2007 12:50:42 +0200" Date: Wed, 16 May 2007 13:50:04 -0400 Message-ID: <5221.1179337804@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/147 X-Sequence-Number: 25467 Johann Spies writes: > * Tom Lane [070514 16:36]: >> $ 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). You got the wrong process then --- maybe the postmaster itself rather than the backend assigned to your psql session? You can identify the backend PID via pg_backend_pid() within the psql session of interest, or look in pg_stat_activity. regards, tom lane