Re: SIGQUIT and lost sequence WAL records - Mailing list pgsql-bugs

From Tom Lane
Subject Re: SIGQUIT and lost sequence WAL records
Date
Msg-id 29856.1455754632@sss.pgh.pa.us
Whole thread Raw
In response to Re: SIGQUIT and lost sequence WAL records  (Michael Paquier <michael.paquier@gmail.com>)
List 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 by date:

Previous
From: Michael Paquier
Date:
Subject: Re: SIGQUIT and lost sequence WAL records
Next
From: Venkata Balaji N
Date:
Subject: Re: BUG #13962: transaction logs growing on standby