From: a f <just1coder@yahoo.ca>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: pgsql-admin@postgresql.org
Subject: Re: Restore a backup to a different disk?
Date: Thu, 22 Jul 2010 10:17:02 -0700 (PDT)
Message-ID: <240044.87213.qm@web65408.mail.ac4.yahoo.com> (raw)
In-Reply-To: <4C48311B0200002500033B27@gw.wicourts.gov>
References: <263251.56844.qm@web65412.mail.ac4.yahoo.com>
<4C48311B0200002500033B27@gw.wicourts.gov>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: just1coder@yahoo.ca, Kevin.Grittner@wicourts.gov
Subject: Re: Restore a backup to a different disk?
In-Reply-To: <240044.87213.qm@web65408.mail.ac4.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox