[GENERAL] Fast Shutdown (SIGINT) results in a CHECKPOINT...

2013-03-20 Thread Sean Chittenden
For a while now I've known that sending a SIGINT can trigger a CHECKPOINT, but I don't know if this is intentional or a bug. Logs from today: 2013-03-20_18:21:43.27642 LOG: received fast shutdown request 2013-03-20_18:21:43.27645 LOG: aborting any active transactions

Re: [GENERAL] Fast Shutdown (SIGINT) results in a CHECKPOINT...

2013-03-20 Thread Peter Eisentraut
On 3/20/13 4:28 PM, Sean Chittenden wrote: For a while now I've known that sending a SIGINT can trigger a CHECKPOINT, but I don't know if this is intentional or a bug. It's intentional. If you don't want that, use SIGQUIT. That's how they are different. Of course, when using SIGQUIT, you

[GENERAL] fast shutdown

2009-06-24 Thread Mary Sipple
When a fast shutdown is done (pg_ctl stop -s -D$PGDATA -mf) active transactions are aborted. Are these transactions logged somewhere re-run when postmaster comes back up? Thanks, Mary

Re: [GENERAL] fast shutdown

2009-06-24 Thread Scott Marlowe
On Wed, Jun 24, 2009 at 12:25 PM, Mary Sipplemsip...@iii.com wrote: When a fast shutdown is done (pg_ctl stop -s -D$PGDATA -mf) active transactions are aborted. Are these transactions logged somewhere re-run when postmaster comes back up? No -- Sent via pgsql-general mailing list