Abandoned wrote: >I tryed pg_dump but it is very slowly. Are there any faster way to >copy database? Actually, I was looking for something along the same line. I often want to test some functionality in my program based on the same dataset. However, dump/restore takes too long to be of any use. Wouldn't it be possible to copy the database folder and somehow instruct the postmaster to include the copied data after a restart? Rainer ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly