Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id B83D56345AB for ; Thu, 22 Jul 2010 14:17:13 -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 38400-08 for ; Thu, 22 Jul 2010 17:17:04 +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 710196343DF for ; Thu, 22 Jul 2010 14:17:04 -0300 (ADT) Received: from [76.13.12.66] by n11.bullet.mail.ac4.yahoo.com with NNFMP; 22 Jul 2010 17:17:03 -0000 Received: from [76.13.10.179] by t7.bullet.mail.ac4.yahoo.com with NNFMP; 22 Jul 2010 17:17:03 -0000 Received: from [127.0.0.1] by omp120.mail.ac4.yahoo.com with NNFMP; 22 Jul 2010 17:17:03 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 418032.32300.bm@omp120.mail.ac4.yahoo.com Received: (qmail 87350 invoked by uid 60001); 22 Jul 2010 17:17:03 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.ca; s=s1024; t=1279819023; bh=KZzoESPfLRzc8I6deMHnyed1XGDOMIpwatrbtDAfdis=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=cjla377u+j16XWeqoGfIfllEvKUneV3qbFR4XLpGth6ikr5/OHRK5a/CTUuoRsqck/cLNXQUj0lHw8oOOtk/oOTWECqRc1ovbcJPcM89KG6bxkzPPtj64fgCSYy95LHGe9Se9PPmiXhYi5hK2gBiymK3r/lRdoEJ8HhhIlvO1Jo= 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=3WC2TMmh7/dUh953mQW5OZ+YBvqMiSh6wlxHVPR3J3B2lbD4bzJ2UIlTDCIku2rCs52zlt+ObaR1Z9XuvJT4YT/s2ki88QEPIFpCu/4iHkfwWicFxDq1In+AAuihXZiKstnoU9S7OR46aWfEVYdx7WXhS3f5xvbH7QTuPI4ErKI=; Message-ID: <240044.87213.qm@web65408.mail.ac4.yahoo.com> X-YMail-OSG: BUERRhkVM1mdrU.U71mubUR8lXYe0r9mC.Yujl82g3VvZeX 1WT6TcpsOr26G49LuytW4O2n205dJ0fnGgwsEOVwg4gFCXFo_J07s4Y71BKL y5je35jiZxKxu0lvq9CUWczy4dtCQuE662yw0vMpKzGhnv..9bXQojnycp8D xYIdHkjg98ECRB3Sy.xd8o7EU0tLVjYx9aMyNBRCUlTeA4yG5zdBuWa0EJeb hr1ZvdIuVbeb8ecKQyBYQ3nqb3gUoQXOLWZyiEfwJPKmBHNiqIEXc7qs6MbO C8JoYh5OiHeZyhIWGNbCKIKrQSRuNgFkVKq6V2vu3QawbhLwASq2Oixxy5U. XYnn4QCTmziDJISNQMQ-- Received: from [66.207.110.134] by web65408.mail.ac4.yahoo.com via HTTP; Thu, 22 Jul 2010 10:17:02 PDT X-Mailer: YahooMailRC/420.4 YahooMailWebService/0.8.105.277674 References: <263251.56844.qm@web65412.mail.ac4.yahoo.com> <4C48311B0200002500033B27@gw.wicourts.gov> Date: Thu, 22 Jul 2010 10:17:02 -0700 (PDT) From: a f Subject: Re: Restore a backup to a different disk? To: Kevin Grittner , pgsql-admin@postgresql.org In-Reply-To: <4C48311B0200002500033B27@gw.wicourts.gov> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1931044126-1279819022=:87213" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201007/156 X-Sequence-Number: 35175 --0-1931044126-1279819022=:87213 Content-Type: text/plain; charset=us-ascii No cluster here, it is just a stand alone db server. Sorry if I sent this to the wrong UG. I have #2 down already; but #1 was focused on backing up MyDatabase that resides on /hda1/pgdata, and restore it as MyDatabase2 on /hda2/pgdata. ________________________________ From: Kevin Grittner To: pgsql-admin@postgresql.org; a f Sent: Thu, July 22, 2010 12:52:59 PM Subject: Re: [ADMIN] Restore a backup to a different disk? a f wrote: > I have added a new disk and would like to do two things: > > 1. Restore a backup to this new disk - /hda2/pgdata/ > 2. Move a database from /hda1/pgdata to /hda2/pgdata/ First I want to be clear about whether you want to restore and move entire database *clusters*, or whether you want to deal with individual databases within a cluster. A cluster is the level at which you start and stop the server process, and it can contain many databases -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin --0-1931044126-1279819022=:87213 Content-Type: text/html; charset=us-ascii
No cluster here, it is just a stand alone db server. Sorry if I sent this to the wrong UG.

I have #2 down already; but #1 was focused on backing up MyDatabase that resides on /hda1/pgdata, and restore it as MyDatabase2 on /hda2/pgdata.

From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: pgsql-admin@postgresql.org; a f <just1coder@yahoo.ca>
Sent: Thu, July 22, 2010 12:52:59 PM
Subject: Re: [ADMIN] Restore a backup to a different disk?

a f <just1coder@yahoo.ca> wrote:

> I have added a new disk and would like to do two things:
>
> 1. Restore a backup to this new disk - /hda2/pgdata/
> 2. Move a database from /hda1/pgdata to /hda2/pgdata/

First I want to be clear about whether you want to restore and move
entire database *clusters*, or whether you want to deal with
individual databases within a cluster.  A cluster is the level at
which you start and stop the server process, and it can contain many
databases

-Kevin

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

--0-1931044126-1279819022=:87213--