Hi, Already doing Vacuum analize procedure on daily basis. But the pg_dump fails on ONLY one table. That table works normal for other operations. But we are feeling uncomfortable to keep using that table as unable to backup. Can anyone give a hint how to fix the pg_dump issue Thanks Manjula --- Dilipkumar <dilipkumar_parikh@xxxxxxxxxxxx> wrote: > Date: Thu, 06 Jul 2006 20:21:53 +0530 > From: Dilipkumar <dilipkumar_parikh@xxxxxxxxxxxx> > To: manjula hettiarachchi <manjula_55@xxxxxxxxx> > Subject: Re: [ADMIN] pg_dump error > > Hi, > > Or try to run vaccum scripts this will help you out. > > manjula hettiarachchi wrote: > > >Hi > > > >How do I optimize? > > > >Thanks in advance > > > >Manjula > > > >--- Dilipkumar <dilipkumar_parikh@xxxxxxxxxxxx> > wrote: > > > > > > > >>Hi, > >> > >>I think if the table is too large then try to > >>optimize the table and > >>check it. > >>then you shall try the command mentioned. > >> > >>manjula hettiarachchi wrote: > >> > >> > >> > >>>Hi, > >>> > >>>Thanks for the reply. > >>> > >>>Actually this is the full command i used: > >>> > >>>pg_dump database_name -t tablename -h > 'localhost' > >>> > >>> > >>-U > >> > >> > >>>postgres -Fc > >>> > >>>As this table is too large cannot use the text > mode > >>>dump. However all other tables get properly > >>> > >>> > >>backed-up > >> > >> > >>>by the above command. Only this particular table > is > >>>giving the error. > >>> > >>>Also this table seem normal for all other > >>> > >>> > >>functions, > >> > >> > >>>and only the dump is not working for it. > >>> > >>>Any Idea? > >>> > >>>Regards > >>> > >>>Manjula > >>> > >>> > >>>--- Dilipkumar <dilipkumar_parikh@xxxxxxxxxxxx> > >>> > >>> > >>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@xxxxxxxxxxxx > >>>> > >>>>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 > >>>> > >>>> > >>>> > >>>> > >>>> > >>>> > >>>__________________________________________________ > >>>Do You Yahoo!? > >>>Tired of spam? Yahoo! Mail has the best spam > >>> > >>> > >>protection around > >> > >> > >>>http://mail.yahoo.com > >>> > >>> > >>> > >>> > >>> > >> > >> > >> > >=== message truncated === > > > > > >__________________________________________________ > >Do You Yahoo!? > >Tired of spam? Yahoo! Mail has the best spam > protection around > >http://mail.yahoo.com > > > > > > > > > -- > Thanks & Regards, > Dilipkumar > DBA Support > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
