Re: Restore a backup to a different disk?

a f <just1coder@yahoo.ca> wrote:

> No cluster here, it is just a stand alone db server.

There's some terminology you've apparently not grasped yet -- when
PostgreSQL is running, the instance of the server is referred to as
a "cluster".  If you're running a PostgreSQL database server, you
are running a cluster, in the terminology of the PostgreSQL world.
Within the cluster you normally have a template0 database, a
template1 database, a postgres database, and one or more application
databases.

> Sorry if I sent this to the wrong UG.

Posting to this list is fine for this question.  pgsql-general or
pgsql-novice would also be OK, but having posted here, don't post on
another list unless the thread here goes dormant for at least a
couple days.

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

> I have #2 down already;

So you moved a PostgreSQL cluster from one mount point to another?
How, exactly, did you do that?

> 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?

-Kevin