From: manjula hettiarachchi <manjula_55@yahoo.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
To: postgresql-l <postgresql-l@groups.ittoolbox.com>
Subject: pg_dump error
Date: Thu, 6 Jul 2006 05:25:24 -0700 (PDT)
Message-ID: <20060706122524.71421.qmail@web50302.mail.yahoo.com> (raw)
In-Reply-To: <f7f6b4c70607060513x7d299fd4saa7b8d640934b362@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: manjula_55@yahoo.com, postgresql-l@groups.ittoolbox.com
Subject: Re: pg_dump error
In-Reply-To: <20060706122524.71421.qmail@web50302.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox