Re: pg_restore valid archive - Mailing list pgsql-general

From Doug McNaught
Subject Re: pg_restore valid archive
Date
Msg-id m37kp68ut9.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:

> So I used:
>
> psql mydb < pgmydb
>
> and it worked like a charm.
>
> What's the deal with pg_restore? Is it just noise?  The
> docs show it working.  Not a big deal, but I can't get it
> to work.

It only works with the '-Ft' and '-Fc' dump formats, since they're not
plain SQL.  Maybe the docs could be clearer...

-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: captainmidgetdonkey@yahoo.com (Captain)
Date:
Subject: ResultSet next() throws Null Pointer Exception
Next
From: "Christopher Kings-Lynne"
Date:
Subject: PostgreSQL talk at UWA