Re: [GENERAL] 9.6 parameters messing up my 9.2 pg_dump/pg_restore

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] 9.6 parameters messing up my 9.2 pg_dump/pg_restore
Дата
Msg-id 24806.1498681821@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] 9.6 parameters messing up my 9.2 pg_dump/pg_restore  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: [GENERAL] 9.6 parameters messing up my 9.2 pg_dump/pg_restore
Список pgsql-general
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> Ken Tanzer wrote:
>> I didn't see any options for dealing with this, though I'm hoping I'm
>> missing something easy or obvious.  Any suggestions or help would be
>> appreciated.  Thanks.

> pg_dump doesn't promise that its output is compatible with servers older
> than itself.  I'm afraid you're stuck with filtering the output somehow
> to remove or maybe comment out those lines.

Generally speaking, it helps a lot if you don't insist on restoring the
output in a single transaction.  In this case, that would allow the
restore to ignore the new parameters and move on.

            regards, tom lane


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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [GENERAL] 9.6 parameters messing up my 9.2 pg_dump/pg_restore
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: [GENERAL] Is the row version available in SQL?