Re: pg_restore vs psql

Поиск
Список
Период
Сортировка
От Josh Goldberg
Тема Re: pg_restore vs psql
Дата
Msg-id 026801c30c3c$2ffbfb80$6605a8c0@laptop
обсуждение исходный текст
Ответ на Re: pg_restore vs psql  ("Nick Fankhauser" <nickf@ontko.com>)
Список pgsql-admin
also, if you store blobs in your database then you need to use pg_dump and
pg_restore to backup/restore them.
----- Original Message -----
From: "Nick Fankhauser" <nickf@ontko.com>

> Generally, I'd say that if you intend to restore the entire contents of
your
> dump file, then using the plain text format (& compressing with gzip if
> needed) is the way to go.
>
> If you need the ability to selectively restore some part of the dump file,
> (like one table) then you should use one of the non-text formats for
pg_dump
> and thus need to restore using pg_restore.


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

Предыдущее
От: "Nick Fankhauser"
Дата:
Сообщение: Re: pg_restore vs psql
Следующее
От: Gémes Géza
Дата:
Сообщение: Users fo ONE database