[Pgpool-general] Questions about pgPool/streaming replication setup

[Tatsuo Ishii]

> Tatsuo,
> 
> (1) do the functions created by install-functions.sh need to be in
> *every* database, or just postgres and template1?

pgpool-regcalss needs to be installed in every database. Others are
need to be installed in just postgres and template1.

> (2) the setup doesn't appear to deal with copying log files (for
> log-based replication) in any way.  How should I deal with this?

I haven't tried yet but I think you need to modify postgresql.conf and
basebackup.sh (recovery.conf part) at least.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp