Re: pg_restore valid archive

From: Doug McNaught <doug(at)wireboard(dot)com>
To: eel(at)javabox(dot)com (Eel)
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_restore valid archive
Date: 2002-02-21 20:05:22
Message-ID: m37kp68ut9.fsf@varsoon.denali.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

eel(at)javabox(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2002-02-21 20:05:59 Re: [HACKERS] fmgr_info: function 20071: cache lookup failed
Previous Message Oliver Elphick 2002-02-21 20:04:24 Re: Using variables from c to be passed into PQexec