Re: restore a dump db from tar file

Поиск
Список
Период
Сортировка
От Alain Roger
Тема Re: restore a dump db from tar file
Дата
Msg-id 75645bbb0810060953u4b5993evea67658e1978245d@mail.gmail.com
обсуждение исходный текст
Ответ на Re: restore a dump db from tar file  (Raymond O'Donnell <rod@iol.ie>)
Список pgsql-general
From the docs:

<quote>
-C
--create

   Begin the output with a command to create the database itself and
reconnect to the created database. (With a script of this form, it
doesn't matter which database you connect to before running the script.)

   This option is only meaningful for the plain-text format. For the
archive formats, you can specify the option when you call pg_restore.
</quote>

So it seems that you can't do it when using a non-text format - you'll
have to do a plain-text dump, and maybe pipe it to tar if you want that.

Ray.

Thanks Ray,

this is also what i found later after my post :-(
everything works well now.

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

Предыдущее
От: Raymond O'Donnell
Дата:
Сообщение: Re: restore a dump db from tar file
Следующее
От: johnf
Дата:
Сообщение: on windows 8.3 many processes - is it normal?