Provided by: pgpool2_4.3.5-1_amd64 bug

NAME

       pg_md5 - produces encrypted password in md5

SYNOPSIS

       pg_md5 [option...] -p

       pg_md5 [option...] password

DESCRIPTION

       pg_md5 produces encrypted password in md5.

OPTIONS

       -p
       --prompt
           Prompt password using standard input.

       -m
       --md5auth
           Produce md5 authentication password to authentication file pool_passwd.

       -u your_username
       --username=your_username
           When producing a md5 authentication password, create the pool_passwd entry for
           your_username.

       -f config_file
       --config-file=config_file
           Specify the path to the pgpool.conf configuration file.

       -i input_file
       --input-file=input_file
           Specifies file containing user name and password pairs.

EXAMPLE

       The following are examples to encrypt your password into md5 hash format for pcp.conf.

               $ pg_md5 -p
               password: [your password]

       or

              $ pg_md5 [your password]
              acbd18db4cc2f85cedef654fccc4a4d8

       pg_md5 can also be used for adding an entry of user name and md5 encrypted password to
       pool_passwd authentication file.

                $ pg_md5 -m -f /path/to/pgpool.conf -u username -p
                password: [your password]

                $ cat /path/to/pool_passwd
                username:md55a231fcdb710d73268c4f44283487ba2

       To avoid password prompt or password in command parameter, pg_md5 can read user
       name:password pairs from file. It will add all user names and md5 hashed password to
       pool_passwd authentication file.

                $ cat users.txt
                username1:secretpassword1
                username2:secretpassword1

                $ pg_md5 -m -f /path/to/pgpool.conf -i users.txt
                trying to read username:password pairs from file users.txt

                $ cat /path/to/pool_passwd
                username1:md533314126ba0b187df1e37f5ce6a489a8
                username2:md58ae92c6e1d6a48d80e2583fe715e2b36

       To just display the md5 hashed string, not adding an entry to pool_passwd, pass a string
       concatenating password and user name. For example, if password is "password" and user name
       is "user", the output would be:

                 $ pg_md5 passworduser
                 4d45974e13472b5a0be3533de4666414

       Please note that the actual entry to be inserted into pool_passwd should have "md5" on top
       of the result string. That is: "md54d45974e13472b5a0be3533de4666414".