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 1265.1290184178@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Upgrading 8.2 to 8.4: pg_restore: did not find magic string in file header\n  (Andreas Laggner <andreas.laggner@vti.bund.de>)
Ответы 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
Andreas Laggner <andreas.laggner@vti.bund.de> writes:
> i cannot restore my data from 8.2 to 8.4 because i always get this error
> message, does anyone know what to do??

It sounds like you're trying to use pg_restore on a plain-text (SQL
script) dump file.  Run it through psql, instead.

            regards, tom lane

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Upgrading 8.2 to 8.4: pg_restore: did not find magic string in file header\n
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Upgrading 8.2 to 8.4: pg_restore: did not find magic string in file header\n