Postgres Pro
Downloads
Home   >   mailing lists

Thread: Not a valid archive? - newbie question

Not a valid archive? - newbie question

From
Jeremy Speer
Date:
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?

Responses of RTFM are welcome if you reference an M and page number :-)

thanks,

-jspeer

Re: Not a valid archive? - newbie question

From
Bruno Wolff III
Date:
On Fri, Jun 13, 2003 at 11:53:25 -0500,
  Jeremy Speer <jspeer@pobox.com> wrote:
> Folks,
>
> Newbie here.... with hopefully a newbie question.
>
> I'm running pg 7.2.3 on RedHat 8... so far with tremendous success.

You should upgrade to at 7.2.4. This won't require an initdb and should
be relatively painless.

>
> I did a pg_dump of a fairly large DB sometime ago... and now i'm trying
> to pg_restore it.

If it is a text dump use psql to do the restore. pg_restore is for use
with nontext dumps.

>
> 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?
>
> Responses of RTFM are welcome if you reference an M and page number :-)
>
> thanks,
>
> -jspeer
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Re: Not a valid archive? - newbie question

From
Stephan Szabo
Date:
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.