Re: [GENERAL] Copy the database..

From: Abandoned <besturk(at)gmail.com>
Date: Fri Nov 02 2007 - 10:38:16 EDT

On Nov 2, 3:49 pm, Sascha Bohnenkamp <asbohnenk...@gmx.de> 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 4: Have you searched our list archives?

               http://archives.postgresql.org/ Received on Tue Nov 6 09:37:55 2007