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...
>