X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 75A7C9FA147 for ; Thu, 6 Jul 2006 09:25:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 81799-06 for ; Thu, 6 Jul 2006 09:25:26 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web50302.mail.yahoo.com (web50302.mail.yahoo.com [206.190.38.56]) by postgresql.org (Postfix) with SMTP id 7714B9FA0EC for ; Thu, 6 Jul 2006 09:25:26 -0300 (ADT) Received: (qmail 71423 invoked by uid 60001); 6 Jul 2006 12:25:24 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=NJK6oegzAKbNFlwS20mR3+3CIpw3JH2OxVqBfsP9PfpNOYr9Eh3U5HksEBrdZFZe8uqbrHnx4UCpvzZwxYsqZPQMqHM8Xt2MjzKpe0s7BHDv52H1Sqo6mQ8kr6npQPiAanYSmssci87rp4+r+9lLXQKJObYxelJ2si8MZCaRoJY= ; Message-ID: <20060706122524.71421.qmail@web50302.mail.yahoo.com> Received: from [203.189.72.83] by web50302.mail.yahoo.com via HTTP; Thu, 06 Jul 2006 05:25:24 PDT Date: Thu, 6 Jul 2006 05:25:24 -0700 (PDT) From: manjula hettiarachchi Subject: pg_dump error To: "pgsql-admin@postgresql.org" , postgresql-l In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/34 X-Sequence-Number: 22280 Hello List I am using postgresql 7.4.7 in a voip production setup. I have been using pg_dump -Fc for regular backing up. Since yesterday i am getting the following error for the command: root# pg_dump -h 'localhost' voipdb -t voipcall -Fc -f voipcall.bak The error is : pg_dump: ERROR: invalid memory alloc request size 4294967293 pg_dump: SQL command to dump the contents of table "voipcall" failed: PQendcopy() failed. pg_dump: Error message from server: ERROR: invalid memory alloc request size 4294967293 pg_dump: The command was: COPY public.voipcall (id, accountid, .........., prefix) TO stdout; However when i tried to Vacuum analyze the same table its fine and no errors. Also the SQL access to the same table runs fine without any errors. Only the pg_dump is failing for this particular table. Can anyone suggest a method to fix this? Thanks in advance Manjula __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com