Provided by: pgpool2_4.1.4-6build1_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.

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 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".