[Pgpool-general] what is /usr/local/etc/pool_passwd

[Tatsuo Ishii]

> Tatsuo,
> 
> Got this error:
> 
> pool_init_pool_passwd: couldn't open /usr/local/etc/pool_passwd. reason:
> Permission denied
> 
> What the heck is pgpool_passwd?  That file is not in the documentation
> anywhere.

It's documented:

Authentication / Access Controls

    * In the replication mode or master/slave mode, trust, clear text
      password, and pam methods are supported. md5 in also supported
      since pgpool-II 3.0. md5 is supported by using
      "pool_passwd". Here are the steps to enable md5 authentication:

         1. Login as the database's operating system user and type
         "pg_md5 --md5auth " user name and md5 encrypted password are
         registered into pool_passwd. If pool_passwd does not exist
         yet, pg_md5 command will automatically create it for you.

         2. The format of pool_passwd is "username:encrypted_passwd".

         3. You also need to add an appropriate md5 entry to
         pool_hba.conf. See Setting up pool_hba.conf for client
         authentication (HBA) for more details.

         4. Please note that the user name and password must be
         identical to those registered in PostgreSQL.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp