Hi
I installed PostgresSQL-8.3 on my linux machine.
The cluster directory is /usr/local/data and I created three databases named 
db1, db2, and db3. db1 is in the default tablespace 'pg_default'. db2 is in 
'/home/tablespace/space1/' and db3 is in '/home/tablespace/space2/'.  I want to 
copy the cluster directory and the db3  tablespace 
folder('/home/tablespace/space2/') without stopping the database server. Then I 
want to use the cluster directory and db3's tablespace in another linux machine 
to recover 'db3' database. Does this way work? If not, why?


Regards,
Hao

Reply via email to