Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2
Дата
Msg-id 201112300859.27115.adrian.klaver@gmail.com
обсуждение исходный текст
Ответ на Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2  (Culley Harrelson <harrelson@gmail.com>)
Список pgsql-general
On Friday, December 30, 2011 8:51:17 am Culley Harrelson wrote:
> This is just the first of many duplicate key errors that cause primary key
> creation statements to fail on other tables.  I grepped for the key but it
> is hard to tell where the problem is with 888 matches.
>
> I will try pg_dump --inserts.  It is a 17G file with copy statements so...
> this should be interesting.  And take a long time.

Might want to try just dumping one table to make it a little easier.

>

--
Adrian Klaver
adrian.klaver@gmail.com

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: How to get the time zone offset
Следующее
От: "Cezariusz Marek"
Дата:
Сообщение: How to get the time zone offset