Fwd: Re: pg_dump error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux