X-Original-To: pgsql-advocacy-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id BE9689FA147 for ; Thu, 6 Jul 2006 09:52:13 -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 85603-08 for ; Thu, 6 Jul 2006 09:52:05 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.190]) by postgresql.org (Postfix) with ESMTP id 05A419FA0EC for ; Thu, 6 Jul 2006 09:52:04 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id g2so154229nfe for ; Thu, 06 Jul 2006 05:52:03 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=S6dXsBalycbh1BNM9RAfNfKeQ0dx6B2kNsnHv00xHrElSQDuAox/rykya+IHAy8hCU+DIMlZvACk1VO3BEcPqjVqsRg7kxIvSdKzRekA97jCePDP9t8b5Y59Nb69itySofoGh8eoPu526PogrHA8zC9mDTjxCjm2NZ4zxANaaVo= Received: by 10.78.166.7 with SMTP id o7mr190732hue; Thu, 06 Jul 2006 05:52:03 -0700 (PDT) Received: by 10.78.177.14 with HTTP; Thu, 6 Jul 2006 05:52:03 -0700 (PDT) Message-ID: Date: Thu, 6 Jul 2006 09:52:03 -0300 From: "Guido Barosio" Subject: FWD: [ADMIN] pg_dump error Cc: pgsql-advocacy In-Reply-To: <44AD0217.5060206@sifycorp.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20060706122524.71421.qmail@web50302.mail.yahoo.com> <44AD0217.5060206@sifycorp.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/20 X-Sequence-Number: 9303 How come? Where does the "postgress" word comes from? I get mad when I read the double ss. Progress Software ?! It's not that famous / big / popular. g.- On 7/6/06, Dilipkumar wrote: > Hi, > > If you are trying to take a table dump try using this > > pd_dump databasename -t tablename > > if you are taking in the same server done mention as localhost just > switch user as postgress and give the above command mentioned. > > manjula hettiarachchi wrote: > > >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 > > > >---------------------------(end of broadcast)--------------------------- > >TIP 2: Don't 'kill -9' the postmaster > > > > > > > > > -- > Thanks & Regards, > Dilipkumar > DBA Support > > ********** DISCLAIMER ********** > Information contained and transmitted by this E-MAIL is proprietary to > Sify Limited and is intended for use only by the individual or entity to > which it is addressed, and may contain information that is privileged, > confidential or exempt from disclosure under applicable law. If this is a > forwarded message, the content of this E-MAIL may not have been sent with > the authority of the Company. If you are not the intended recipient, an > agent of the intended recipient or a person responsible for delivering the > information to the named recipient, you are notified that any use, > distribution, transmission, printing, copying or dissemination of this > information in any way or in any manner is strictly prohibited. If you have > received this communication in error, please delete this mail & notify us > immediately at admin@sifycorp.com > > Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. www.sifymax.com > > Get to see what's happening in your favourite City on Bangalore Live! www.bangalorelive.in > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > -- Guido Barosio ----------------------- http://www.globant.com guido.barosio@globant.com