> AFAIK stopping the server, zipping data dir, and restarting > the server creates a zip file which is not easily portable to > other computers due to some ntfs file system permission problems. > IIRC you have to re-assign owner and change permissions after you copy your data dir to the new server. Regards, Gevik ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match