maybe pg_dump | pg_undump could work? I mean pg_dump with the appropriate parameters and undump directly to the other database? This may one of the fastest ways to do it I think. Abandoned schrieb: > 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 2: Don't 'kill -9' the postmaster
