Re: Is pg_restore in 10.6 working?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Is pg_restore in 10.6 working?
Дата
Msg-id 28066.1542048297@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Is pg_restore in 10.6 working?  (David <dlbarron28@gmail.com>)
Ответы Re: Is pg_restore in 10.6 working?  (Rob Sargent <robjsargent@gmail.com>)
Re: Is pg_restore in 10.6 working?  (raf <raf@raf.org>)
Список pgsql-general
David <dlbarron28@gmail.com> writes:
> I have some experience with different versions of Postgres, but I'm just
> getting around to using pg_restore, and it's not working for me at all.
> ...
> But a matching pg_restore command does nothing.
> pg_restore -U postgres -f predata.sql -v

This command expects to read from stdin and write to predata.sql, so
it's not surprising that it's just sitting there.  What you want
is something along the lines of

pg_restore -U postgres -d dbname -v <predata.sql

            regards, tom lane


В списке pgsql-general по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Is pg_restore in 10.6 working?
Следующее
От: Scot Kreienkamp
Дата:
Сообщение: RE: help with aggregation query across a second text array column