Reading this thread confuses me a little bit. There is no need to backup
a cluster in order to move it to another disk within the same machine.
Stopping the Database, moving $PGDATA, adjusting scripts and routines if
nessecary and firing up the whole thing would do fine.
regards
-Andreas
Good day all,
I am fairly new with PQSQL and am slowly picking things up - 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/
Any help is most appreciated, thank you.
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
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
a f just1co...@yahoo.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
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?
Yes.
I used pg_dump to make the backup.
a f just1co...@yahoo.ca wrote:
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?
Yes.
I used pg_dump to make the backup.