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