pgsql: During Hot Standby, fix drop database when sessions idle.

From: sriggs(at)postgresql(dot)org (Simon Riggs)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: During Hot Standby, fix drop database when sessions idle.
Date: 2010-01-10 15:44:28
Message-ID: 20100110154428.D5E2C7541B9@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
During Hot Standby, fix drop database when sessions idle.
Previously we only cancelled sessions that were in-transaction.

Simple fix is to just cancel all sessions without waiting. Doing
it this way avoids complicating common code paths, which would
not be worth the trouble to cover this rare case.

Problem report and fix by Andres Freund, edited somewhat by me

Modified Files:
--------------
pgsql/src/backend/commands:
dbcommands.c (r1.230 -> r1.231)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/dbcommands.c?r1=1.230&r2=1.231)
pgsql/src/backend/storage/ipc:
procarray.c (r1.54 -> r1.55)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/ipc/procarray.c?r1=1.54&r2=1.55)
pgsql/src/include/storage:
procarray.h (r1.28 -> r1.29)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/storage/procarray.h?r1=1.28&r2=1.29)

Browse pgsql-committers by date

  From Date Subject
Next Message Magnus Hagander 2010-01-10 15:54:11 pgsql: Update Windows installation notes.
Previous Message Magnus Hagander 2010-01-10 14:16:08 pgsql: Create typedef pgsocket for storing socket descriptors.