Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 4DCBC6322E8
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 22 Jul 2010 16:18:09 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 96790-01 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 22 Jul 2010 19:18:02 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from n11.bullet.mail.ac4.yahoo.com (n11.bullet.mail.ac4.yahoo.com
	[74.6.228.83])
	by mail.postgresql.org (Postfix) with SMTP id C896A632BE7
	for <pgsql-admin@postgresql.org>; Thu, 22 Jul 2010 16:18:01 -0300 (ADT)
Received: from [76.13.12.65] by n11.bullet.mail.ac4.yahoo.com with NNFMP;
	22 Jul 2010 19:18:00 -0000
Received: from [76.13.10.172] by t6.bullet.mail.ac4.yahoo.com with NNFMP;
	22 Jul 2010 19:18:00 -0000
Received: from [127.0.0.1] by omp113.mail.ac4.yahoo.com with NNFMP;
	22 Jul 2010 19:18:00 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 476364.96048.bm@omp113.mail.ac4.yahoo.com
Received: (qmail 75497 invoked by uid 60001); 22 Jul 2010 19:18:00 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.ca; s=s1024;
	t=1279826280; bh=IojgtfekxaPkVPk7jSARZqhczf52WxaDQ2BbqqxlC3o=;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type;
	b=EuF7HVRYXCa5GRk76SrKRAhcky2qgN7EzbBvr4ijCiS9b8uGlOrDFS32s83pWv5HznEPEGuv5DL69SfeVfg7vehv8McsJJpQgOZBkuJiTYyYd4x/Z8ALo0KmHEjVAahaHyEDDn2oh9YKDP/ppdnXF0dadCArBPqP7BgKJf66mi4=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.ca;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type;
	b=kig8aDFfRS4ciR7Q1Q9Z6uYLknMixsm8oytZ154FBaLV+ICV4B93HlkCdrpzBIeicR85pSaXn8SP7IWTbugBnM6yfS0YkcKnr/GHB3k+wJk8rCfcr1Tf64Y/pHLDwNtIE90LUrkf3t5HXee1nx2CGSuGKj38z5Bf3cyEt+xrRnM=;
Message-ID: <248984.75183.qm@web65402.mail.ac4.yahoo.com>
X-YMail-OSG: MSNhzdQVM1l.nkJXWFG8q0pkLIScWgX3tzcHd8N4vC7RegE
	tRc9yMx7XgGa7oJCt1sesAD6AM66636.hVAFzmaRC1rPWLbDF6wUUOKQSB4e
	2jLyWRt.D2MaryWyiVCh_BqSv05CEIq6bCj8VvUN_9nJWCtF0_ArYyEl.Ca7
	.01ax9Ne0E6gS.OoeQQGjSYs44XONWnaG.Fi4mYf7wBMMoJWRvaIRK0tramW
	IRPBX3nPAel9Fj548JlrJCl.8JcPbsTIL3EyC5rxxdH8DZajZpTocXgYltKT
	aOaYJ6wx9uezov0VNNEgG7f4P9U2_gt6VQFsDL1k-
Received: from [66.207.110.134] by web65402.mail.ac4.yahoo.com via HTTP;
	Thu, 22 Jul 2010 12:18:00 PDT
X-Mailer: YahooMailRC/420.4 YahooMailWebService/0.8.105.277674
References: <263251.56844.qm@web65412.mail.ac4.yahoo.com>
	<4C48311B0200002500033B27@gw.wicourts.gov>
	<240044.87213.qm@web65408.mail.ac4.yahoo.com>
	<4C484E9E0200002500033B56@gw.wicourts.gov>
Date: Thu, 22 Jul 2010 12:18:00 -0700 (PDT)
From: a f <just1coder@yahoo.ca>
Subject: Re: Restore a backup to a different disk?
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>, pgsql-admin@postgresql.org
In-Reply-To: <4C484E9E0200002500033B56@gw.wicourts.gov>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1140954889-1279826280=:75183"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.782 tagged_above=-10 required=5 tests=BAYES_50=0.8,
	HTML_FONT_FACE_BAD=0.981, HTML_MESSAGE=0.001,
	RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: *
X-Archive-Number: 201007/158
X-Sequence-Number: 35177

--0-1140954889-1279826280=:75183
Content-Type: text/plain; charset=us-ascii




>> but #1 was focused on backing up MyDatabase that resides on
>> /hda1/pgdata, and restore it as MyDatabase2 on /hda2/pgdata.

>Do you already have the backup you want to restore?  If so, how was
>it made, exactly?


Yes. 
I used pg_dump to make the backup.


--0-1140954889-1279826280=:75183
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:'times new roman', 'new york', times, serif;font-size:12pt"><div><font class="Apple-style-span" face="arial, helvetica, sans-serif" size="3"><span class="Apple-style-span" style="font-size: 13px;"><font class="Apple-style-span" face="'times new roman', 'new york', times, serif" size="4"><span class="Apple-style-span" style="font-size: 16px;"><br></span></font></span></font></div><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div style="font-family:arial, helvetica, sans-serif;font-size:13px"> <br>&gt;&gt; but #1 was focused on backing up MyDatabase that resides on<br>&gt;&gt; /hda1/pgdata, and restore it as MyDatabase2 on /hda2/pgdata.<br> <br>&gt;Do you already have the backup you want to restore?&nbsp; If so, how was<br>&gt;it made, exactly?<br><br></div><div style="font-family:arial, helvetica,
 sans-serif;font-size:13px">Yes.&nbsp;</div><div style="font-family:arial, helvetica, sans-serif;font-size:13px">I used pg_dump to make the backup.</div></div><div style="position:fixed"></div>


</div><br></body></html>
--0-1140954889-1279826280=:75183--