Still hoping for a transaction manager so I can implement 2PC using postgres_fdw.
It is a blocking protocol, This mean if the coordinator crash , some participants will never resolve their transactions.
After a participant has sent an agreement message to the coordinator, it will completely block until a commit or rollback is received from the coordinator but this will never happen.