Обсуждение: how to ensure parallel restore consistency ?

Поиск
Список
Период
Сортировка

how to ensure parallel restore consistency ?

От
"熊艳辉"
Дата:
PG version 15.4
i read code about pg_dump & pg_restore, there is an option -j/--jobs related with parallel,
i have questions about parallel dump & restore
1) In pg_dump when running parallel dump, it can ensure dump data consistency using synchronized snaphot,
why should it start a trasaction in every parallel jobs, also set isolation level ,read only, and no need commit trasaction
2) In pg_restore there are no actions same with pg_dump under parallel mode, how to ensure restore data consistency?
no trasaction and no commit action
3) when we do dump or restore under parallel mode, should we set whole database read-only(write behavior forbidden??)