Re: [GENERAL] 9.6 parameters messing up my 9.2 pg_dump/pg_restore
| От | Ken Tanzer |
|---|---|
| Тема | Re: [GENERAL] 9.6 parameters messing up my 9.2 pg_dump/pg_restore |
| Дата | |
| Msg-id | CAD3a31VRtpdpagowOBmcGrDoOkTyRRqiSpAQwJ9aat6pJAi+kQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [GENERAL] 9.6 parameters messing up my 9.2 pg_dump/pg_restore (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: [GENERAL] 9.6 parameters messing up my 9.2 pg_dump/pg_restore
Re: [GENERAL] 9.6 parameters messing up my 9.2 pg_dump/pg_restore |
| Список | pgsql-general |
Thanks for the responses. For me, using the 9.2 binary was the winner. Shoulda thought of that!
Well sure, I can see it increases your chances of getting _something_ restored. But there's also a lot to be said for ensuring that _all_ your data restored, and did so correctly, no?
On Wed, Jun 28, 2017 at 1:30 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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
Cheers,
Ken
--

Ken

AGENCY Software
A Free Software data system
By and for non-profits
(253) 245-3801
learn more about AGENCY or
follow the discussion.
В списке pgsql-general по дате отправления: