Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 1770A9FA173 for ; Fri, 15 Dec 2006 05:56:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 64671-08 for ; Fri, 15 Dec 2006 05:56:15 -0400 (AST) X-Greylist: delayed 00:23:19.353938 by SQLgrey-1.7.4 Received: from p15105778.pureserver.info (p15105778.pureserver.info [217.160.133.184]) by postgresql.org (Postfix) with ESMTP id 1745F9FA0EF for ; Fri, 15 Dec 2006 05:56:24 -0400 (AST) Received: by p15105778.pureserver.info (Postfix, from userid 65534) id EE315440D5; Fri, 15 Dec 2006 10:33:20 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by server1.proventis.net (Postfix) with ESMTP id 722E2C44096 for ; Fri, 15 Dec 2006 10:28:57 +0100 (CET) Received: from server1.proventis.net ([127.0.0.1]) by localhost (server1.proventis.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09736-09 for ; Fri, 15 Dec 2006 10:28:56 +0100 (CET) Received: from [192.168.22.130] (tmarkus.proventis.net [192.168.22.130]) by server1.proventis.net (Postfix) with ESMTP id 0C51BC44094 for ; Fri, 15 Dec 2006 10:28:56 +0100 (CET) Message-ID: <45826AD7.7050005@proventis.net> Date: Fri, 15 Dec 2006 10:28:55 +0100 From: Thomas Markus Organization: proventis GmbH User-Agent: Thunderbird 1.5.0.8 (X11/20061025) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: out of memory in backup and restore Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at proventis.net X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50 X-Spam-Level: X-Archive-Number: 200612/208 X-Sequence-Number: 24000 Hi, i'm running pg 8.1.0 on a debian linux (64bit) box (dual xeon 8gb ram) pg_dump creates an error when exporting a large table with blobs (largest blob is 180mb) error is: pg_dump: ERROR: out of memory DETAIL: Failed on request of size 1073741823. pg_dump: SQL command to dump the contents of table "downloads" failed: PQendcopy() failed. pg_dump: Error message from server: ERROR: out of memory DETAIL: Failed on request of size 1073741823. pg_dump: The command was: COPY public.downloads ... TO stdout; if i try pg_dump with -d dump runs with all types (c,t,p), but i cant restore (out of memory error or corrupt tar header at ...) how can i backup (and restore) such a db? kr Thomas