Re: [HACKERS] [GENERAL] Template zero xid issue

2007-08-08 Thread Tom Lane
Decibel! <[EMAIL PROTECTED]> writes: > On Tue, Aug 07, 2007 at 06:46:05PM -0400, Tom Lane wrote: >> I'm tempted to stop accepting connections once we start the shutdown >> checkpoint (ie, tell the bgwriter to shut down). This would at least >> limit the width of the window in which incoming connec

Re: [HACKERS] [GENERAL] Template zero xid issue

2007-08-07 Thread Decibel!
On Tue, Aug 07, 2007 at 06:46:05PM -0400, Tom Lane wrote: > I'm tempted to stop accepting connections once we start the shutdown > checkpoint (ie, tell the bgwriter to shut down). This would at least > limit the width of the window in which incoming connections get ignored. > We could also close t

Re: [HACKERS] [GENERAL] Template zero xid issue

2007-08-07 Thread Tom Lane
Gregory Stark <[EMAIL PROTECTED]> writes: > "Tom Lane" <[EMAIL PROTECTED]> writes: >> 4. Keep spawning a child, but mark it in the BackendList as known >> doomed, and don't count such children when deciding if it's OK to >> terminate. The problem with this idea is that such children will >> still

Re: [HACKERS] [GENERAL] Template zero xid issue

2007-08-07 Thread Gregory Stark
"Tom Lane" <[EMAIL PROTECTED]> writes: > 4. Keep spawning a child, but mark it in the BackendList as known > doomed, and don't count such children when deciding if it's OK to > terminate. The problem with this idea is that such children will > still be connected to shared memory, and we really do

Re: [HACKERS] [GENERAL] Template zero xid issue

2007-08-07 Thread Tom Lane
[ redirected to -hackers for discussion of bug fix ] "Keaton Adams" <[EMAIL PROTECTED]> writes: > Some additional information I just received from one of the operations > personnel: > 1. I set pg_database.datallowconn to true on template0 in an attempt to > log into the database with psql and per