Re: pg_dump shared locks documentation

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: pg_dump shared locks documentation
Дата
Msg-id 202203151506.55cjea5lmp2l@alvherre.pgsql
обсуждение исходный текст
Ответ на pg_dump shared locks documentation  (Florin Irion <irionr@gmail.com>)
Ответы Re: pg_dump shared locks documentation  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-docs
On 2022-Mar-15, Florin Irion wrote:

> In the `pg_dump` documentation we talk about "shared locks", but IIUC,
> we actually take `AccessShareLock`s.  This might be misunderstood with
> the `ShareLock`.

This might be a bit excessive to have in the main text.  What about
adding a footnote to point out the exact lock level that is meant, with
a link to the server doc page that explains each lock level?
Something like this:

>          Requesting exclusive locks on database objects while running a parallel dump could
>          cause the dump to fail. The reason is that the <application>pg_dump</application> leader process
> -        requests shared locks on the objects that the worker processes are going to dump later
> +        requests shared locks<footnote>The precise lock level used is <literal>ACCESS SHARE</literal>.
> +        See <xref ... /> for more information.</footnote> on the objects that the worker processes are
>          going to dump later

...

> @@ -870,7 +870,7 @@ PostgreSQL documentation
>        <term><option>--lock-wait-timeout=<replaceable class="parameter">timeout</replaceable></option></term>
>        <listitem>
>         <para>
> -        Do not wait forever to acquire shared table locks at the beginning of

Same here.

-- 
Álvaro Herrera



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

Предыдущее
От: Florin Irion
Дата:
Сообщение: pg_dump shared locks documentation
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump shared locks documentation