From: Ferdinand Smit <ferdinand@telegraafnet.nl>
To: pgsql-admin@postgresql.org
Subject: pg_dump error
Date: Tue, 1 Oct 2002 17:52:49 +0200
Message-ID: <200210011752.49941.ferdinand@telegraafnet.nl> (raw)
Hi,
What does this mean ?!? Is this a corrupt database, a bug or has the pg_dump
not enough memory ?
And ... how can i solve this problem ?
$ pg_dump login | gzip > login.dump.gz
pg_dump: ERROR: MemoryContextAlloc: invalid request size 4294967293
pg_dump: lost synchronization with server, resetting connection
pg_dump: SQL command to dump the contents of table "postcodereeks" failed:
PQendcopy() failed.
pg_dump: Error message from server: pg_dump: The command was: COPY
"postcodereeks" TO stdout;
$ psql -c 'COPY "postcodereeks" TO stdout;' login > /tmp/postcodereeks
ERROR: MemoryContextAlloc: invalid request size 4294967293
lost synchronization with server, resetting connection
Config:
Machine; dual PIII with 1 Gb memory
DB version: PG 7.2.1
postgres.conf:
<zip>
shared_buffers = 2048
sort_mem = 1024
<zip>
Regards,
Ferdinand
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: ferdinand@telegraafnet.nl
Subject: Re: pg_dump error
In-Reply-To: <200210011752.49941.ferdinand@telegraafnet.nl>
* 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