[pgpool-hackers: 3876] Re: Proposal: virtual database for pgpool commands

Tatsuo Ishii ishii at sraoss.co.jp
Fri Mar 12 15:26:14 JST 2021


> Currently Pgpool-II's SQL-like commands such as "show pool_nodes"
> cannot be executed unless at least one backend is alive. If we have
> "virtual database", we could eliminate this limitation because the
> SQL-like command actually does not access backend.  The virtual
> database is distinguished from ordinary database by it's
> name. "pgpool" can be one of the candidates but it may conflict with
> existing database name. Probably we should have new parameter
> something like "virtual_database_name"?

One of the concern is authentication. Since in this pgpool does not
use the authentication mechanism provided by PostgreSQL, it needs to
be authenticated somewhere else. Maybe pool_hba.conf?

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