if you dump/undump using a pipe there is no temp file ... Abandoned schrieb: > On Nov 2, 3:49 pm, Sascha Bohnenkamp <asbohnenk...@xxxxxx> wrote: >> 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... > > Thank you.. > Are there any way to copy database without dump or any temp files ? > (If there is a temp my harddisk not enough for this operation :( ) > ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
