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.gritt...@wicourts.gov> To: pgsql-admin@postgresql.org; a f <just1co...@yahoo.ca> Sent: Thu, July 22, 2010 12:52:59 PM Subject: Re: [ADMIN] Restore a backup to a different disk? a f <just1co...@yahoo.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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin