pg_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