[pgpool-general: 6144] Re: What happens when node is assigned as shutdown

Tatsuo Ishii ishii at sraoss.co.jp
Tue Jun 26 22:11:56 JST 2018

> Hi,
> I wanted to understand what happens to a session that was opened from the
> pool to   one of the nodes in my cluster (query that is taking x time).
> Suddenly there was a network conflict between the pool node and the
> database node and the pool change the status of the database node to
> shutdown(the node is slave). What happens to the query that runned ? What
> happens to the session that was open ?

The session will be closed. This is pretty much similar when you
directly connect to PostgreSQL.

> Will the output of the query will
> come back to the user ?

Though it really depends on the timing of failure, probably the output
of the query will not come bacl to the user in most cases.

Best regards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php

More information about the pgpool-general mailing list