[GENERAL] Copy the database..

From: Abandoned <besturk(at)gmail.com>
Date: Fri Nov 02 2007 - 09:20:15 EDT

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 Received on Tue Nov 6 09:37:42 2007