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 2020070909314883952256@highgo.ca
обсуждение исходный текст
Ответ на pg_resetwal --next-transaction-id may cause database failed to restart.  ("movead.li@highgo.ca" <movead.li@highgo.ca>)
Ответы Re: pg_resetwal --next-transaction-id may cause database failed to restart.  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers

>> ISTM that a reasonable compromise is that if you use -x (or -c, -m, -O)
>> and the input value is outside the range supported by existing files,
>> then it's a fatal error; unless you use --force, which turns it into
>> just a warning.
 
>One potential problem is that you might be using --force for some
>other reason and end up forcing this, too. But maybe that's OK.
Yes it's true, so I try to add a new option to control this behavior, you
can see it in the last mail with attach.
 
>Perhaps we should consider the idea of having pg_resetwal create the
>relevant clog file and zero-fill it, if it doesn't exist already,
>rather than leaving that to to the DBA or the postmaster binary to do
>it. It seems like that is what people would want to happen in this
>situation.
I have considered this idea, but I think it produces files uncontrolled
by postmaster, so I think it may be unacceptable and give up.

In the case we force to write an unsafe value, we can create or extend
related files I think. Do you have any further idea, I can work out a new
patch.


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

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

Предыдущее
От: Alexander Korotkov
Дата:
Сообщение: Re: jsonpath versus NaN
Следующее
От: "movead.li@highgo.ca"
Дата:
Сообщение: Re: A patch for get origin from commit_ts.