From: | Sascha Bohnenkamp <asbohnenkamp(at)gmx(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Copy the database.. |
Date: | 2007-11-02 15:30:08 |
Message-ID: | 5p0u40Fp3194U1@mid.individual.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 :( )
>
From | Date | Subject | |
---|---|---|---|
Next Message | paul rivers | 2007-11-02 17:19:22 | Re: young guy wanting (Postgres DBA) ammo |
Previous Message | Lew | 2007-11-02 14:58:29 | Re: young guy wanting (Postgres DBA) ammo |