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