;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
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
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
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