Re: pg_resetwal --next-transaction-id may cause database failed to restart.

Поиск
Список
Период
Сортировка
От movead.li@highgo.ca
Тема Re: pg_resetwal --next-transaction-id may cause database failed to restart.
Дата
Msg-id 2020070809210566340927@highgo.ca
обсуждение исходный текст
Ответ на Re: pg_resetwal --next-transaction-id may cause database failed to restart.  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers

>The rationale for this interface is unclear to me.  Please explain what
>happens in each case?
>In my proposal, we'd have:
>* Bad value, no --force:
>  - program raises error, no work done.
>* Bad value with --force:
>  - program raises warning but changes anyway.
>* Good value, no --force:
>  - program changes value without saying anything
>* Good value with --force:
>  - same
You have list all cases, maybe you are right it needs to raise a warning
when force a Bad value write which missed in the patch.
And I use '--test' in the patch, not '--force' temporary, maybe it needs
a deep research and discuss.

>The rationale for this interface is convenient knowledgeable access: the
>DBA runs the program with value X, and if the value is good, then
>they're done.  If the program raises an error, DBA has a choice: either
>run with --force because they know what they're doing, or don't do
>anything because they know that they would make a mess.
Yes that's it, in addition the raised error, can tell the DBA to input a good
value.


Regards,
Highgo Software (Canada/China/Pakistan)
URL : www.highgo.ca
EMAIL: mailto:movead(dot)li(at)highgo(dot)ca

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

Предыдущее
От: torikoshia
Дата:
Сообщение: Re: Is it useful to record whether plans are generic or custom?
Следующее
От: "movead.li@highgo.ca"
Дата:
Сообщение: Re: A patch for get origin from commit_ts.