Re: SIGQUIT and lost sequence WAL records

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: SIGQUIT and lost sequence WAL records
Дата
Msg-id 29856.1455754632@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: SIGQUIT and lost sequence WAL records  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-bugs
Michael Paquier <michael.paquier@gmail.com> writes:
> Do you think we should add a mention regarding SIGQUIT/stop-immediate
> regarding the fact that the application needs to commit the
> transaction that used nextval() with synchronous_commit = on to keep
> it consistent at recovery?

Meh.  In the normal case where you just do "SELECT nextval()" and use the
result externally, there's going to be an implicit commit before you get
the data back.  So I think you really have to be taking deliberate aim at
your foot in order to get burnt like this.

            regards, tom lane

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: SIGQUIT and lost sequence WAL records
Следующее
От: Venkata Balaji N
Дата:
Сообщение: Re: BUG #13962: transaction logs growing on standby