Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 2E02E632F21
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sat, 20 Feb 2010 13:53:17 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 37634-05 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sat, 20 Feb 2010 17:53:05 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from gw.wicourts.gov (gwmta.wicourts.gov [165.219.244.99])
	by mail.postgresql.org (Postfix) with ESMTP id 7484662DBD2
	for <pgsql-admin@postgresql.org>; Sat, 20 Feb 2010 13:53:06 -0400 (AST)
Received: from Courts-MTA by gw.wicourts.gov
	with Novell_GroupWise; Sat, 20 Feb 2010 11:53:05 -0600
Message-Id: <4B7FCD1A020000250002F419@gw.wicourts.gov>
X-Mailer: Novell GroupWise Internet Agent 8.0.1 
Date: Sat, 20 Feb 2010 11:52:58 -0600
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: <gkbrown22@gmail.com>,<pgsql-admin@postgresql.org>
Subject: Re: pg_dump/restore problems
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.535 tagged_above=-10 required=5 tests=AWL=-0.795,
	BAYES_20=-0.74
X-Spam-Level: 
X-Archive-Number: 201002/154
X-Sequence-Number: 33757

Glen Brown  wrote:
 
> When I dump this table using pg_dump -Fc it creates a 15 gb file. I
> am trying to restore in into a database that has 100gb of free disk
> space and it consumes it all and fails to finish the restore.
 
What is the platform?  (I remember having problems with large file
handling in PostgreSQL on Windows, back when I used Windows.)
 
Can you see where the space is going when this happens?
 
-Kevin