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

[Tatsuo Ishii]

> 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
Japanese:http://www.sraoss.co.jp