Re: pg_restore dumps all data to the terminal

On Thursday, April 26, 2018, Ron <ronljohnsonjr(at)gmail(dot)com> wrote:

> Hi,
>
> v9.6.8, restoring from 8.4.17
>
> This command dumps not just the schema to the terminal (technically,
> nohup.out) but the actual data. How do I stop that? There's no --quiet,
> and that's not what I want anyway...
>
> pg_restore -cC --if-exists -e -Fd -j4 ${SOURCE}/${DB}
>
>
"pg_restore can operate in two modes. If a database name is specified,
pg_restore connects 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."

You haven't specified a database so you get the second mode.

David J.