Re: copying a database without dumping it

Поиск
Список
Период
Сортировка
От Tino Wildenhain
Тема Re: copying a database without dumping it
Дата
Msg-id 43A14F78.4020605@wildenhain.de
обсуждение исходный текст
Ответ на copying a database without dumping it  (Marc Brünink <mbruen@smartsoft.de>)
Ответы Re: copying a database without dumping it  (Marc Brünink <mbruen@smartsoft.de>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Pandurangan R S
Дата:
Сообщение: Re: copying a database without dumping it
Следующее
От: Marc Brünink
Дата:
Сообщение: Re: copying a database without dumping it