how to ensure parallel restore consistency ?

Поиск
Список
Период
Сортировка
От 熊艳辉
Тема how to ensure parallel restore consistency ?
Дата
Msg-id tencent_27AFC0EB2E64146062C2E769@qq.com
обсуждение исходный текст
Список pgsql-hackers
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??)

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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: 2023-08-10 release announcement draft
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: pg_upgrade fails with in-place tablespace