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@xxxxxxxxxxxx>
To: pgsql-admin@xxxxxxxxxxxxxx; a f <just1coder@xxxxxxxx>
Sent: Thu, July 22, 2010 12:52:59 PM
Subject: Re: Restore a backup to a different disk?
a f <just1coder@xxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
