From: | Abandoned <besturk(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Copy the database.. |
Date: | 2007-11-03 13:42:09 |
Message-ID: | 1194097329.919769.308870@o38g2000hse.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Nov 2, 5:30 pm, Sascha Bohnenkamp <asbohnenk(dot)(dot)(dot)(at)gmx(dot)de> wrote:
> if you dump/undump using a pipe there is no temp file ...
>
> Abandoned schrieb:
>
>
>
> > On Nov 2, 3:49 pm, Sascha Bohnenkamp <asbohnenk(dot)(dot)(dot)(at)gmx(dot)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 :( )- Hide quoted text -
>
> - Show quoted text -
I tryed pg_dump but it is very slowly. Are there any faster way to
copy database?
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Treat | 2007-11-03 13:59:14 | Re: young guy wanting (Postgres DBA) ammo |
Previous Message | Niklas Johansson | 2007-11-03 13:26:52 | Re: unexpected behavior in combining timestamps with times zone and intervals |