Re: Not a valid archive? - newbie question

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Not a valid archive? - newbie question
Дата
Msg-id 20030613102930.H65514-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на Not a valid archive? - newbie question  (Jeremy Speer <jspeer@pobox.com>)
Список pgsql-general
On Fri, 13 Jun 2003, Jeremy Speer wrote:

> Folks,
>
> Newbie here.... with hopefully a newbie question.
>
> I'm running pg 7.2.3 on RedHat 8... so far with tremendous success.
>
> I did a pg_dump of a fairly large DB sometime ago... and now i'm trying
> to pg_restore it.
>
> I get a reponse saying "does not appear to be a valid archive"
>
> I can view the dump in a text editor.... it *seems* fine and intact.
>
> Any suggestions?

If you did a text format pg_dump (ie no -F option) then you use psql to
restore it.  pg_restore is for the special archive file formats.

> Responses of RTFM are welcome if you reference an M and page number :-)
In this case I think it's in the current pg_dump man page.  I'd guess it's
in 7.2's as well, but I don't have a system to check.


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

Предыдущее
От: Teodor Sigaev
Дата:
Сообщение: Re: tsearch - v2 new dict
Следующее
От: Robert Treat
Дата:
Сообщение: Re: [HACKERS] SAP and MySQL ... [and Benchmark]