pg_md5

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