Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 94003633AE1
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sat, 20 Feb 2010 16:41:41 -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 68294-07 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sat, 20 Feb 2010 20:41:27 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-px0-f191.google.com (mail-px0-f191.google.com
	[209.85.216.191])
	by mail.postgresql.org (Postfix) with ESMTP id C49F563287B
	for <pgsql-admin@postgresql.org>; Sat, 20 Feb 2010 16:41:30 -0400 (AST)
Received: by pxi29 with SMTP id 29so711668pxi.1
	for <pgsql-admin@postgresql.org>; Sat, 20 Feb 2010 12:41:28 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type;
	bh=TV6WvFIJgjvDxgUqyWqfDlD6mhF4nkcYSJU36eeEXWc=;
	b=IkAPML3Vk7IVY4xAiFTY9xSXXZA0QV2HR2jjI7rMQdadPFOL3Urckk1Z9bdMzv2W4p
	CMsArH2BC+hgnqjowYJH/QXZJ8RAUHTXpbuYqjG6wWSay4mfywhNd9JhSeMNVBGhAOoU
	S+PydMn1Or1eKGmALBIZZSaFGqZ1/Atyj5298=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=QWrcx5Q0oPjmRykVO2dtTBY8004DI8gH9u/PH67yXy61w4p3ruB1fg0xfqt19Ef4Xr
	QvC7o37kUKAQKUjfNsNEgwma3ByW3LqageHPkNBiZP0/bjnPZ4pIk7cdOFObGpbjiL07
	jzIMxutt4Yh72PQgeNVnOJLdQDcTJ0XD5Bwpo=
MIME-Version: 1.0
Received: by 10.142.56.8 with SMTP id e8mr8231257wfa.82.1266698488652;
 Sat, 20
	Feb 2010 12:41:28 -0800 (PST)
In-Reply-To: <4B7FCD1A020000250002F419@gw.wicourts.gov>
References: <4B7FCD1A020000250002F419@gw.wicourts.gov>
Date: Sat, 20 Feb 2010 12:41:28 -0800
Message-ID: <fb9f1c031002201241x70181771x95a73c1d212950a4@mail.gmail.com>
Subject: Re: pg_dump/restore problems
From: Glen Brown <gkbrown22@gmail.com>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: pgsql-admin@postgresql.org
Content-Type: multipart/alternative; boundary=001636b42f4074246304800e3938
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.598 tagged_above=-10 required=5
	tests=BAYES_00=-2.599, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201002/156
X-Sequence-Number: 33759

--001636b42f4074246304800e3938
Content-Type: text/plain; charset=ISO-8859-1

I am using Ubuntu 8LTS on both systems. How can tell where the space is
going?

thanks for the help
-glen

Glen Brown


On Sat, Feb 20, 2010 at 9:52 AM, Kevin Grittner <Kevin.Grittner@wicourts.gov
> wrote:

> 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
>
>
>

--001636b42f4074246304800e3938
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div>I am using Ubuntu 8LTS on both systems. How can tell where the space i=
s going? </div>
<div>=A0</div>
<div>thanks for the help</div>
<div>-glen</div>
<div><br clear=3D"all">Glen Brown<br><br><br></div>
<div class=3D"gmail_quote">On Sat, Feb 20, 2010 at 9:52 AM, Kevin Grittner =
<span dir=3D"ltr">&lt;<a href=3D"mailto:Kevin.Grittner@wicourts.gov">Kevin.=
Grittner@wicourts.gov</a>&gt;</span> wrote:<br>
<blockquote style=3D"BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex=
; PADDING-LEFT: 1ex" class=3D"gmail_quote">
<div class=3D"im">Glen Brown =A0wrote:<br><br>&gt; When I dump this table u=
sing pg_dump -Fc it creates a 15 gb file. I<br>&gt; am trying to restore in=
 into a database that has 100gb of free disk<br>&gt; space and it consumes =
it all and fails to finish the restore.<br>
<br></div>What is the platform? =A0(I remember having problems with large f=
ile<br>handling in PostgreSQL on Windows, back when I used Windows.)<br><br=
>Can you see where the space is going when this happens?<br><font color=3D"=
#888888"><br>
-Kevin<br><br><br></font></blockquote></div><br>

--001636b42f4074246304800e3938--