Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_restore dumps all data to the terminal - Mailing list pgsql-admin

From David G. Johnston
Subject Re: pg_restore dumps all data to the terminal
Date
Msg-id CAKFQuwbDvoF1wCqoCWKVZmK=Ec67meFVJg-LvKiW3XxKrtZ9fg@mail.gmail.com
Whole thread Raw
In response to pg_restore dumps all data to the terminal  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: pg_restore dumps all data to the terminal  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-admin
Tree view
On Thursday, April 26, 2018, Ron <ronljohnsonjr@gmail.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.

pgsql-admin by date:

Previous
From: Ron
Date:
Subject: pg_restore dumps all data to the terminal
Next
From: Ron
Date:
Subject: Re: pg_restore dumps all data to the terminal