Re: Is pg_restore in 10.6 working?

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: Is pg_restore in 10.6 working?
Дата
Msg-id 708fdafe-dfa3-7d26-59fa-992595671b77@gmail.com
обсуждение исходный текст
Ответ на Re: Is pg_restore in 10.6 working?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Is pg_restore in 10.6 working?  (David <dlbarron28@gmail.com>)
Список pgsql-general
On 11/12/18 11:44 AM, Tom Lane wrote:
> 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
>

In this case, does the "General options" -f make sense? restoring to a file?



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

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