I observed one strange behavior today that if postmaster process gets crashed/killed, then it kill all background processes but not the client backend process. Moreover it is also allowed to execute query on the connected client session without any other background process. But If I try to execute some command (like checkpoint) from the client session which requires any background task to perform, it fails because it cannot find the corresponding background process (like checkpoint process).
I am not sure if this is already known behavior but I found it to be little awkward. This may lead to some unknown behavior in user application. Currently All background process keeps checking if Postmaster is Alive while they wait for any event but for client backend process there is no such mechanism. One way to handle this issue will be to check whether postmaster is alive after every command read but it will add extra cost for each query execution. Any comments? Thanks and Regards, Kumar Rajeev Rastogi
