Re: [GENERAL] 9.6 parameters messing up my 9.2 pg_dump/pg_restore
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 по дате отправления:
Предыдущее
От: Alain ToussaintДата:
Сообщение: Re: [GENERAL] Insertion of large xml files into PostgreSQL 10beta1
Следующее
От: Timokhin MaximДата:
Сообщение: [GENERAL] duplicate key value violates unique constraint and duplicated records