Re: pg_restore dumps all data to the terminal
| От | David G. Johnston |
|---|---|
| Тема | Re: pg_restore dumps all data to the terminal |
| Дата | |
| Msg-id | CAKFQuwbDvoF1wCqoCWKVZmK=Ec67meFVJg-LvKiW3XxKrtZ9fg@mail.gmail.com обсуждение исходный текст |
| Ответ на | pg_restore dumps all data to the terminal (Ron <ronljohnsonjr@gmail.com>) |
| Ответы |
Re: pg_restore dumps all data to the terminal
|
| Список | pgsql-admin |
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 по дате отправления: