Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group