Fwd: Re: pg_dump error

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@sifycorp.com> wrote:

> Date: Thu, 06 Jul 2006 20:21:53 +0530
> From: Dilipkumar <dilipkumar_parikh@sifycorp.com>
> To: manjula hettiarachchi <manjula_55@yahoo.com>
> 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@sifycorp.com>
> 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@sifycorp.com>
> >>>
> >>>
> >>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
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
>
>>>__________________________________________________
> >>>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