Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 198729FB7AC for ; Tue, 29 May 2007 06:39:21 -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 58313-09 for ; Tue, 29 May 2007 06:39:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail2.sun.ac.za (mail2.sun.ac.za [146.232.64.14]) by postgresql.org (Postfix) with ESMTP id 164E69FB792 for ; Tue, 29 May 2007 06:39:14 -0300 (ADT) Received: from burger.sun.ac.za ([146.232.128.30]) by mail2.sun.ac.za with esmtp (Exim 4.50) id 1HsyAY-00015l-US for pgsql-admin@postgresql.org; Tue, 29 May 2007 11:39:10 +0200 Received: from js by burger.sun.ac.za with local (Exim 4.63) (envelope-from ) id 1HsyAY-0006Ot-Pv for pgsql-admin@postgresql.org; Tue, 29 May 2007 11:39:10 +0200 Date: Tue, 29 May 2007 11:39:10 +0200 From: Johann Spies To: pgsql-admin@postgresql.org Subject: Re: ERROR: invalid memory alloc request size Message-ID: <20070529093910.GA24350@sun.ac.za> Mail-Followup-To: Johann Spies , pgsql-admin@postgresql.org References: <5221.1179337804@sss.pgh.pa.us> <20070517132033.GA9482@sun.ac.za> <25608.1179412804@sss.pgh.pa.us> <20070518122942.GA28931@sun.ac.za> <27574.1179501021@sss.pgh.pa.us> <20070521140718.GC10742@sun.ac.za> <10687.1179758440@sss.pgh.pa.us> <20070528134559.GC5615@sun.ac.za> <20070528144651.GA7795@alvh.no-ip.org> <28065.1180365517@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <28065.1180365517@sss.pgh.pa.us> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.145 tagged_above=0 required=5 tests=AWL=0.144, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200705/301 X-Sequence-Number: 25621 On Mon, May 28, 2007 at 11:18:37AM -0400, Tom Lane wrote: > Alvaro Herrera writes: > > Johann Spies wrote: > >> #3 0x00000000005ff1c8 in perform_default_encoding_conversion ( > >> src=0x2b881e87f040 "\"2007-04-20\" \"18:07:06\" \"192.168.0.100\" \"73\" \"http://www.kerkbode.co.za/kerkbode/images/blank.gif\\\"\"\n\"2007-04-20\" \"18:07:06\" \"192.168.0.100\" \"69\" \"http://develop.christians.co.za/phpAdsNew/adx.js\"\n\"20"..., len=337739539, is_client_to_server=5 '\005') at mbutils.c:461 > > > > Interesting. You are passing a single 300 MB string here, not > > 90-something char lines. The problem is probably in newlines. Why are > > they not getting used as line separators escapes me. > > Stripped of gdb's own backslashing, the data seems to be > > ...images/blank.gif\"" ^^ And that is where the problem is. > "2007... > > which leads me to think that the dump was generated on the assumption > that backslash is the escape character, but is being reloaded under a > different assumption. Backslash is indeed used as escape character. I see now that I should have specified it in my copy command! I have figured out how to do it now and successfully imported that part of the logs into a table. Thanks for your help. Regards Johann -- Johann Spies Telefoon: 021-808 4036 Informasietegnologie, Universiteit van Stellenbosch "Let no man despise thy youth; but be thou an example of the believers, in word, in conversation, in charity, in spirit, in faith, in purity." I Timothy 4:12