[pgpool-hackers: 1005] Health check database and user

[Tatsuo Ishii]

[Subject changed to more appropriate one]

> Here is a proposal for upcoming pgpool-II 3.5.
> 
> The problem:
> 
> Certain systems (heroku) do not allow users to connect to
> postgres/template1 database.  So health checking or streaming delay
> checking do not work since they use the databases.
> 
> Proposal:
> 
> Add new directives that specify objective databases for health
> checking and streaming replication delay checking. If they are not
> specified, pgpool-II will use the predefined database.
> 
> sr_check_database
> health_check_database

Also probably we need to allow to specify:

sr_check_user
health_check_user

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp