[pgpool-general: 6491] Re: Reset old data in pgpool

Tatsuo Ishii ishii at sraoss.co.jp
Wed Apr 3 23:43:05 JST 2019

> Hello to everyone. A couple of days I've spent trying to understand how
> pgpool-II works.
> After some cruel experiments I've broken my pgpool cluster (1 primary and 1
> standby nodes) :-)
> I've re-configured it and launched pgpool again. And now all nodes have
> "standby" role no matter what i do. Is there any way of reset pgpool? Nodes
> without pgpool operating correctly: one is primary, other is standby.

It is likely that Pgpool-II failed to detect the primary. Which
version of Pgpool-II are you using? Can you share Pgpool-II debug log
right after starting up it? It detects the primary upon starting up.

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