X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5883ED1B4A8 for ; Tue, 8 Jun 2004 18:35:01 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 04954-06 for ; Tue, 8 Jun 2004 21:34:57 +0000 (GMT) Received: from stamp.musicrebellion.com (unknown [209.120.177.10]) by svr1.postgresql.org (Postfix) with ESMTP id 1343DD1B459 for ; Tue, 8 Jun 2004 18:34:54 -0300 (ADT) Received: from adsl-66-73-138-18.dsl.ipltin.ameritech.net ([66.73.138.18] helo=musicrebellion.com) by stamp.musicrebellion.com with asmtp (Exim 4.30 #2 (Debian)) id 1BXoF8-0003Kd-Vx for ; Tue, 08 Jun 2004 16:34:51 -0500 Message-ID: <40C630E0.6080901@musicrebellion.com> Date: Tue, 08 Jun 2004 16:34:24 -0500 From: Kris Kiger User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020623 Debian/1.0.0-0.woody.1 X-Accept-Language: en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Upper limit for a dump file? Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/94 X-Sequence-Number: 13754 I am trying to restore a dump of two independant databases. Each database is the same in table structure (there is only one table that consists of 5 integers, a timestamp with time zone, and a boolean). Here are the number of rows: DB1 - 115,539,855 rows DB2 - 118,022,948 rows There are no keys/indexes/etc on the table. The uncompressed tar file is 5.5GB. I am running PG 7.4. When I try to move this data to another database (via pg_dump & pg_restore) it fails each time, for each database) with: pg_restore: [archiver (db)] error returned by PQputline I find it highly unlikely that I have corrupted data in each database, since each were generated on different postgres installations on different machines. I can still query the original databases (DB1 & DB2) with no problem. It looks like all of the data is intact. Any ideas what may be the root of the problem or how I can find out more about this error PQputline returned? In advance, I appreciate your help! Kris