From: himanshu.joshi <himanshu.joshi@orkash.com>
To: pgsql-admin@postgresql.org
Subject: Problem in taking the database dump
Date: Tue, 18 Sep 2012 14:27:40 +0530
Message-ID: <50583784.9000100@orkash.com> (raw)
Hi,
I am facing a strange problem while taking dump of a postgres
database using pg_dump.
whenever I start the pg_dump command to take the backup of that
particular database, it stops within few minutes with the below
mentioned error:
*[root@s8-msd-2 bin]# ./pg_dump -Upostgres pdc_uima_dummy >
/hdd2-1/pdc_uima_dummy_108_18092012.sql
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: invalid memory alloc request
size 18446744073709551613
pg_dump: The command was: COPY public.object_data (id, wkb_geometry,
obj_type_id, obj_beginoffset, obj_endoffset, source_id, sentence_id,
last_mod_date, obj_norm_value, obj_text, entity_name, frequency) TO
stdout;*
After repeating the process many times I am getting the same error every
time.
Due to space problem in the database server, the tablespace of that
particular database is mounted on another storage server. Is this
mounting is the cause of the error or anything else? Plz suggest.
Thanks & Regards,
Himanshu Joshi
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: himanshu.joshi@orkash.com
Subject: Re: Problem in taking the database dump
In-Reply-To: <50583784.9000100@orkash.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