pgpool2 master fail problem

Hi all,
i try to build a postgresql cluster using postgresql 9.1.3 and pgpool2 3.1.2.
I want to setup this cluster as a master/slave with streaming copy. Everything is ok execept the case when the masters fails, and i try to recover it, because the old master recovers as master instead of slave. I have installed pgpool-walrecrunning on both servers but still does not seems to work.
any ideea ?

I'm not sure I fully understand your complain but I guess you expected
the failed master became new standby by just restarting it? That is
not allowed with streaming replication system anyway. You need to
recreate the failed master as a new standby from base backup. Pgpool
provides a convenient way called "online recovery" to do that. See
pgpool manual or tutorials at pgpool web site (http://www.pgpool.net),
especially this one:
http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.1/index.html
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

On 04/17/12 7:10 AM, Videanu Adrian wrote:

i try to build a postgresql cluster using postgresql 9.1.3 and pgpool2 3.1.2.
I want to setup this cluster as a master/slave with streaming copy. Everything is ok execept the case when the masters fails, and i try to recover it, because the old master recovers as master instead of slave. I have installed pgpool-walrecrunning on both servers but still does not seems to work.

in addition to the streaming replication built into postgres, you need
some form of cluster management software running over the top of this to
manage the transition states, ensure that you don't have two masters,
etc. as another said, the previously failed master has to be brought
online as a new slave

--
john r pierce N 37, W 122
santa cruz ca mid-left coast