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 DF0DAD1B257 for ; Tue, 20 Jul 2004 12:10:05 -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 50316-05 for ; Tue, 20 Jul 2004 15:09:57 +0000 (GMT) Received: from stamp.musicrebellion.com (unknown [209.120.177.10]) by svr1.postgresql.org (Postfix) with ESMTP id D7712D1B211 for ; Tue, 20 Jul 2004 12:09:53 -0300 (ADT) Received: from dsl093-203-229.ind1.dsl.speakeasy.net ([66.93.203.229] helo=musicrebellion.com) by stamp.musicrebellion.com with asmtp (Exim 4.30 #2 (Debian)) id 1BmwFZ-0006UB-Rc for ; Tue, 20 Jul 2004 10:09:50 -0500 Message-ID: <40FD359F.4040304@musicrebellion.com> Date: Tue, 20 Jul 2004 10:09:19 -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: Re: Large file support needed? Trying to identify root of References: <40F6A366.5040701@musicrebellion.com> <40F6B86B.3020400@spacemonkeylabs.com> <40F6DC6F.4000707@musicrebellion.com> <40FC20F0.1000402@musicrebellion.com> <25097.1090267221@sss.pgh.pa.us> 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: 200407/225 X-Sequence-Number: 14293 Thanks Tom, -Fc worked great! I appreciate your help. Kris Tom Lane wrote: >Kris Kiger writes: > > >>I've got a database that is a single table with 5 integers, a timestamp >>with time zone, and a boolean. The table is 170 million rows in length. >> The contents of the tar'd dump file it produced using: >> pg_dump -U postgres -Ft test > test_backup.tar >>is: 8.dat (approximately 8GB), a toc, and restore.sql. >> >> > >Try -Fc instead. I have some recollection that tar format has a >hard-wired limit on the size of individual members. > > regards, tom lane > >---------------------------(end of broadcast)--------------------------- >TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > >