Re: Restore a backup to a different disk?

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(dot)Grittner(at)wicourts(dot)gov>
To: pgsql-admin(at)postgresql(dot)org; a f <just1coder(at)yahoo(dot)ca>
Sent: Thu, July 22, 2010 12:52:59 PM
Subject: Re: [ADMIN] Restore a backup to a different disk?

a f <just1coder(at)yahoo(dot)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