Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 007ED632BF3 for ; Sat, 20 Feb 2010 22:36:03 -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 31433-09 for ; Sun, 21 Feb 2010 02:35:44 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com [74.125.82.174]) by mail.postgresql.org (Postfix) with ESMTP id DC23D63161C for ; Sat, 20 Feb 2010 22:35:52 -0400 (AST) Received: by wya21 with SMTP id 21so70357wya.19 for ; Sat, 20 Feb 2010 18:35:51 -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 :content-transfer-encoding; bh=rE2oZBOvs2p9fdknZxurCFBaglOrA81Wu1OsEi2zis8=; b=UpsPdUSRaquYpfiGQVQRb/CjynDWPFzjPBjyBSseT7DY8M9cFsWnAoF2orda9OrHPh 1DSlXuuH3X3MyUlzlqWJcSEHmmHew1oHf7LbaiHx3LamJ4lMxXVKa1X+vMcbvqRif+K1 PkYDN5+uIITQBKRcYeywh+qMvMuKpqzxwMPIw= 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:content-transfer-encoding; b=CqU/kf0LshheZoc6epxm9ItqllveEdLWu5+axiDCidV8625Pfn2dEGFsfBI46YhKqm xJGf+Bh9x0RC9YKHOVNeyHKOnmV/6yacuQB/Z4X/5FogRoD/vrYkY7H2GCZOXv+6EuN6 b4x60w09Twgj5BAbdvebqcA6ZjN+xsPNZnJ/U= MIME-Version: 1.0 Received: by 10.216.188.139 with SMTP id a11mr4581302wen.115.1266719750912; Sat, 20 Feb 2010 18:35:50 -0800 (PST) In-Reply-To: <4B803F28020000250002F424@gw.wicourts.gov> References: <4B803F28020000250002F424@gw.wicourts.gov> Date: Sat, 20 Feb 2010 19:35:50 -0700 Message-ID: Subject: Re: pg_dump/restore problems From: Scott Marlowe To: Kevin Grittner Cc: gkbrown22@gmail.com, pgsql-admin@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.401 tagged_above=-10 required=5 tests=AWL=0.198, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/165 X-Sequence-Number: 33768 On Sat, Feb 20, 2010 at 6:59 PM, Kevin Grittner wrote: > Glen Brown =A0wrote: > >> I am using Ubuntu 8LTS on both systems. How can tell where the >> space is going? > > Maybe someone has a more sophisticated way, but I'd be poking around > with "du -shx" requests against the contents of various directories > during the run. =A0Maybe run "vmstat 1" in another shell, piping the > results to a file. Also look at iotop. Pretty sure it'll work on an up to date ubuntu 8.04 LT= S.