| Lists: | pgsql-general |
|---|
| From: | Jeremy Speer <jspeer(at)pobox(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Not a valid archive? - newbie question |
| Date: | 2003-06-13 16:53:25 |
| Message-ID: | 8CF483B1-9DBF-11D7-A2D9-000A95A0DF3C@pobox.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Jeremy Speer <jspeer(at)pobox(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Not a valid archive? - newbie question |
| Date: | 2003-06-13 17:09:20 |
| Message-ID: | 20030613170920.GA18746@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
On Fri, Jun 13, 2003 at 11:53:25 -0500,
Jeremy Speer <jspeer(at)pobox(dot)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(at)postgresql(dot)org)
| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Jeremy Speer <jspeer(at)pobox(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Not a valid archive? - newbie question |
| Date: | 2003-06-13 17:32:15 |
| Message-ID: | 20030613102930.H65514-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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.