Chris Marcellino <[EMAIL PROTECTED]> writes:
> I was actually referring to the check that the current SysV code does  
> on the pid that is stored in the shmem header. I presume that if the  
> backend is dead, the kill(hdr->creatorPID, 0) returning zero would  
> suffice for confirming the existence of the other backend process.

No, that's not relevant, because only the postmaster's PID will be there
--- that test is actually more or less redundant with the existing lockfile checks.  The thing that the SysV attachment
count is useful for is detecting whether there are orphaned backends
still alive in the database (and potentially changing it, hence the

We've speculated on occasion about using file locking in some form as a
substitute mechanism for detecting this, but that seems to just bring
its own set of not-too-portable assumptions.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to