> 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
