Re: [GENERAL] File system level copy

2012-11-15 Thread Wang, Hao
;t work, I will consider to use pg_dump. Thank you for your feedback. -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Albe Laurenz Sent: Thursday, November 15, 2012 4:52 PM To: Wang, Hao; pgsql-general@postgresql.org S

Re: [GENERAL] File system level copy

2012-11-14 Thread Wang, Hao
at pg_dump will probably have bad performance. -Original Message- From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at] Sent: Wednesday, November 14, 2012 6:49 PM To: Wang, Hao; pgsql-general@postgresql.org Subject: RE: [GENERAL] File system level copy Hao Wang wrote: > I installed PostgresS

[GENERAL] File system level copy

2012-11-14 Thread 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 c

[GENERAL] File system level copy

2012-11-14 Thread 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 cl