X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id A599D9FA5E6 for ; Thu, 22 Jun 2006 22:58:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 91712-07 for ; Thu, 22 Jun 2006 22:58:22 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 030069FA2F4 for ; Thu, 22 Jun 2006 22:58:22 -0300 (ADT) Received: from [10.82.1.60] (docboy.decibel.org [65.86.67.34]) (using TLSv1 with cipher RC4-SHA (128/128 bits)) (No client certificate requested) by noel.decibel.org (Postfix) with ESMTP id 0488F56441; Thu, 22 Jun 2006 20:58:15 -0500 (CDT) In-Reply-To: <11486.1150909222@sss.pgh.pa.us> References: <11486.1150909222@sss.pgh.pa.us> Mime-Version: 1.0 (Apple Message framework v750) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <5F1778F3-ACEA-44C3-B895-D651EF62CBBA@pervasive.com> Cc: "Nicola Mauri" , pgsql-admin@postgresql.org Content-Transfer-Encoding: 7bit From: Jim Nasby Subject: Re: Dump size bigger than pgdata size? Date: Thu, 22 Jun 2006 20:58:14 -0500 To: Tom Lane X-Mailer: Apple Mail (2.750) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/204 X-Sequence-Number: 22166 On Jun 21, 2006, at 12:00 PM, Tom Lane wrote: > This could be avoided by using COPY BINARY format, but I don't see any > very nice way to do that in the context of pg_dump --- it needs to > intermix COPY data with SQL commands ... Would the tar or custom format allow for this? IIRC, at least tar puts all the copied data into separate files... -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461