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
Список 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 по дате отправления: