Обсуждение: File system level copy

Поиск
Список
Период
Сортировка

File system level copy

От
"Wang, Hao"
Дата:

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?