> 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
mastersfails, and i try to recover it, because the old master recovers as master instead of slave. I have installed
pgpool-walrecrunningon 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