Re: Upgrading 8.2 to 8.4: pg_restore: did not find magic string in file header\n

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Upgrading 8.2 to 8.4: pg_restore: did not find magic string in file header\n
Дата
Msg-id 17681.1290206733@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Upgrading 8.2 to 8.4: pg_restore: did not find magic string in file header\n  (Adrian Klaver <adrian.klaver@gmail.com>)
Ответы Re: Upgrading 8.2 to 8.4: pg_restore: did not find magic string in file header\n  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Upgrading 8.2 to 8.4: pg_restore: did not find magic string in file header\n  (Adrian Klaver <adrian.klaver@gmail.com>)
Список pgsql-general
Adrian Klaver <adrian.klaver@gmail.com> writes:
> Now I understand. I wonder if this would be a good time to ask about
> whether pg_restore could be made to work with plain-text files:)

Not in any particularly useful way --- the plain text dump wouldn't
really support selective restore, etc etc.

> ... Though I could see a shortcut that passes a plain text file to
> psql or at least creates an error message that says:

> "Please use psql with the -f option to restore this file"

Yeah, I was thinking a hint might be the most useful fix too.

            regards, tom lane

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

Предыдущее
От: Andy Colson
Дата:
Сообщение: Re: Best practice to get performance
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Upgrading 8.2 to 8.4: pg_restore: did not find magic string in file header\n