Hi.. I want to copy my database.. I have a database which is name db01 and i want to copy it as name db01copy ? How can i do this ? This database is very big 200GB so i want to the fastest way. Also if you suggest pg_dump how can i remove the dump data after copying ? Note: I have a root account with ssh if it is necessary i use ssh. I'm sorry for my bad english. Kind regards... ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend