[pgpool-hackers: 1005] Health check database and user
Tatsuo Ishii
ishii at postgresql.org
Fri Aug 14 13:28:28 JST 2015
[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
More information about the pgpool-hackers
mailing list