Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 67E80476395 for ; Tue, 1 Oct 2002 11:52:49 -0400 (EDT) Received: from smtp0.telegraaf.net (smtp0.telegraaf.net [217.196.45.130]) by postgresql.org (Postfix) with ESMTP id 573E04767C1 for ; Tue, 1 Oct 2002 11:52:45 -0400 (EDT) Received: from server9.telegraafnet.nl (server9.telegraafnet.nl [192.168.1.9]) by smtp0.telegraaf.net (Postfix) with ESMTP id 34B36439CE for ; Tue, 1 Oct 2002 17:52:50 +0200 (CEST) Received: from c22601 (c22601.ws.tem.nl [192.168.1.61]) by server9.telegraafnet.nl (8.11.1/8.11.1/Debian 8.11.0-6) with ESMTP id g91Fqoe10356 for ; Tue, 1 Oct 2002 17:52:50 +0200 X-Authentication-Warning: server9.telegraafnet.nl: Host c22601.ws.tem.nl [192.168.1.61] claimed to be c22601 Content-Type: text/plain; charset="us-ascii" From: Ferdinand Smit To: pgsql-admin@postgresql.org Subject: pg_dump error Date: Tue, 1 Oct 2002 17:52:49 +0200 User-Agent: KMail/1.4.3 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200210011752.49941.ferdinand@telegraafnet.nl> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/3 X-Sequence-Number: 5861 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: shared_buffers = 2048 sort_mem = 1024 Regards, Ferdinand