Re: Operation log for major operations

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: Operation log for major operations
Дата
Msg-id
20221123090021.ba5johlgwwdx2nzm@alvherre.pgsql
Ответ на
Список
Дерево обсуждения
Operation log for major operations Dmitry Koval <d.koval@postgrespro.ru>
Re: Operation log for major operations Justin Pryzby <pryzby@telsasoft.com>
Re: Operation log for major operations Dmitry Koval <d.koval@postgrespro.ru>
Re: Operation log for major operations Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Operation log for major operations Dmitry Koval <d.koval@postgrespro.ru>
Re: Operation log for major operations vignesh C <vignesh21@gmail.com>
Re: Operation log for major operations Dmitry Koval <d.koval@postgrespro.ru>
Re: Operation log for major operations vignesh C <vignesh21@gmail.com>
Re: Operation log for major operations Dmitry Koval <d.koval@postgrespro.ru>
Re: Operation log for major operations Ted Yu <yuzhihong@gmail.com>
Re: Operation log for major operations Dmitry Koval <d.koval@postgrespro.ru>
Re: Operation log for major operations Ted Yu <yuzhihong@gmail.com>
Re: Operation log for major operations Dmitry Koval <d.koval@postgrespro.ru>
Re: Operation log for major operations "Gregory Stark (as CFM)" <stark.cfm@gmail.com>
Re: Operation log for major operations Dmitry Koval <d.koval@postgrespro.ru>
Re: Operation log for major operations Justin Pryzby <pryzby@telsasoft.com>
Re: Operation log for major operations Tom Lane <tgl@sss.pgh.pa.us>
Re: Operation log for major operations Dmitry Koval <d.koval@postgrespro.ru>
Re: Operation log for major operations Kirk Wolak <wolakk@gmail.com>
Re: Operation log for major operations Dmitry Koval <d.koval@postgrespro.ru>
On 2022-Nov-21, Dmitry Koval wrote:

> Concepts.
> ---------
> * operation log is placed in the file 'global/pg_control', starting from
> position 4097 (log size is 4kB);

I think storing this in pg_control is a bad idea.  That file is
extremely critical and if you break it, you're pretty much SOL on
recovering your data.  I suggest that this should use a separate file.

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/
"All rings of power are equal,
But some rings of power are more equal than others."
                                 (George Orwell's The Lord of the Rings)


В списке pgsql-hackers по дате отправления
От: David Rowley
Дата:
От: Alvaro Herrera
Дата:
FAQ