I have following problem regarding the pg-pool (3.3.3)

  1. When master fails, automatic failover happens and standby is promoted to master. But this new master don't have any replicators. Other slave servers still thinks as old master is their master and trying replicate from it.

  2. Now insert is waiting indefinitely until synchronous replication happens. This wait is indefinite since now there's no replication happens from new master.

Is this the correct behaviour of pg-pool ?

Now in this setup I need to sync the old master manually and setup the replication. After everything setup pg-pool fails to find primary node. This primary node finding process success, after I comment # - Backend Connection Settings - on pgpool.conf, start pg-pool and again uncomment the connection settings, restart the pg-pool.

bumped to the homepage by Community 2 days ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.