Re: copying a database without dumping it

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: Marc Brünink <mbruen(at)smartsoft(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: copying a database without dumping it
Date: 2005-12-15 11:11:52
Message-ID: 43A14F78.4020605@wildenhain.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marc Brünink schrieb:
> Hi list,
>
...
> Now I'l try a custom dump. Perhaps this will suffice. But I guess it's
> impossible for a dump to be as fast as a cp. So if a cp would be
> possible I would favour it. Oh, and did I tell: Everything have to be
> done tommorow..... *sigh*
>
Actually its faster. Custom dump is the way to go
because its much more flexible then dumping plaintext.

I'd not use pg_dumpall but pg_dump for each DB in turn.
See also the various compression options or if short
on free space try uncompressed custom dump and
rar.

Since the dump only dumps DDL and Data, its much less
data then your pg_data directory currently has.

HTH
Tino Wildenhain

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc Brünink 2005-12-15 11:24:55 Re: copying a database without dumping it
Previous Message Pandurangan R S 2005-12-15 11:07:48 Re: copying a database without dumping it