Re: Restore a backup to a different disk?

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-admin(at)postgresql(dot)org>,"a f" <just1coder(at)yahoo(dot)ca>
Subject: Re: Restore a backup to a different disk?
Date: 2010-07-22 18:58:54
Message-ID: 4C484E9E0200002500033B56@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message a f 2010-07-22 19:18:00 Re: Restore a backup to a different disk?
Previous Message a f 2010-07-22 17:17:02 Re: Restore a backup to a different disk?