pgsql: During Hot Standby, fix drop database when sessions idle. - Mailing list pgsql-committers

From sriggs@postgresql.org (Simon Riggs)
Subject pgsql: During Hot Standby, fix drop database when sessions idle.
Date
Msg-id 20100110154428.D5E2C7541B9@cvs.postgresql.org
Whole thread Raw
List 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)

pgsql-committers by date:

Previous
From: mha@postgresql.org (Magnus Hagander)
Date:
Subject: pgsql: Create typedef pgsocket for storing socket descriptors.
Next
From: mha@postgresql.org (Magnus Hagander)
Date:
Subject: pgsql: Update Windows installation notes.