pg_restore: fails to restore post-data items due to circular FK deadlock

Поиск
Список
Период
Сортировка
От vaibhave postgres
Тема pg_restore: fails to restore post-data items due to circular FK deadlock
Дата
Msg-id CAM_eQjwLbRsdPF2=Yip05QNb-tyb2LXkAqfSkuVKpZRNhRmJmA@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_restore: fails to restore post-data items due to circular FK deadlock  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения
Repro steps

1. Create a database which has circular foreign key dependencies. (or use the sql script which I have shared), restore the pre-data section first.
2. pg_dump -Fc --section=post-data
3. pg_restore --jobs > 1

pg_restore fails to record the dependency between the foreign keys and tries to process them in parallel (see the attached log file for details)
Вложения

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

Предыдущее
От: Daniel Gustafsson
Дата:
Сообщение: Re: BUG #18484: "Cannot enlarge string buffer" during parallel execution of prepared statement/partitioning
Следующее
От: Etsuro Fujita
Дата:
Сообщение: Re: BUG #18467: postgres_fdw (deparser) ignores LimitOption