Re: Not a valid archive? - newbie question

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
Thread:
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)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Teodor Sigaev 2003-06-13 17:24:12 Re: tsearch - v2 new dict
Previous Message Reynard Hilman 2003-06-13 17:05:32 Re: full featured alter table?