Re: pg_restore a dump in -Fd format?

On 05/03/2018 12:02 PM, Don Seiler wrote:
> On Thu, May 3, 2018 at 11:36 AM, Ron <ronljohnsonjr(at)gmail(dot)com
> <mailto:ronljohnsonjr(at)gmail(dot)com>> wrote:
>
>
>
> Since "pg_dump -Fd" needs a "--file" option to say where to put the
> dump directory, it seemed reasonable that "pg_restore -Fd" would need
> a --file to know where the dump directory is.
>
>
> It would make sense, but the docs do explicitly say it's for an output
> file. The output file is the SQL script generation option when not running
> on an actual database.
>
> pg_restorecan operate in two modes. If a database name is
> specified,pg_restoreconnects to that database and restores archive
> contents directly into the database. Otherwise, a script containing
> the SQL commands necessary to rebuild the database is created and
> written to a file or standard output. This script output is equivalent
> to the plain text output format ofpg_dump. Some of the options
> controlling the output are therefore analogous topg_dumpoptions.
>
>
> I'm curious if you've overwritten your dump files now with that output?

After I got the correct command, it soon failed with a "file not found"
error.  I'm re-downloading everything now.

--
Angular momentum makes the world go 'round.