Re: pg_restore valid archive - Mailing list pgsql-general

From Doug McNaught
Subject Re: pg_restore valid archive
Date
Msg-id m3g03u8vka.fsf@varsoon.denali.to
Whole thread Raw
In response to pg_restore valid archive  (eel@javabox.com (Eel))
List pgsql-general
eel@javabox.com (Eel) writes:

> Hi,
>   I'm trying to upgrade to 7.2 from 7.0.  I first tried pg_dump from
> 7.0 and then pg_restore.  It gave me "input file does not appear to be
> a valid archive". I did a bit of research and found that versions of
> pg_dump/restore are incompatible, so I pg_dumped it from the 7.2
> pg_dump.  It still gives me the same error.  What do I need for a
> valid archive?  I'm doing something like:

If you're dumping in straight SQL format (the default), just use
'psql' to do the restore:

$ psql -f <dumpfile> <dbname>

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

pgsql-general by date:

Previous
From: "Peter Darley"
Date:
Subject: Re: Postgresql/linux speed + reliability
Next
From: "Kelly McTiernan"
Date:
Subject: Re: Solaris Performance