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
Список
Дерево обсуждения
pg_restore: fails to restore post-data items due to circular FK deadlock vaibhave postgres <postgresvaibhave@gmail.com>
Re: pg_restore: fails to restore post-data items due to circular FK deadlock Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_restore: fails to restore post-data items due to circular FK deadlock vaibhave postgres <postgresvaibhave@gmail.com>
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
Дата:
От: Etsuro Fujita
Дата:
