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 w

[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 > 2013-03-20_18:21:43.2

Re: [GENERAL] fast shutdown

2009-06-24 Thread Scott Marlowe
On Wed, Jun 24, 2009 at 12:25 PM, Mary Sipple 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 (pgsql-general@postgre

[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