[pgpool-hackers: 2930] Re: pg_md5: Usability

[Tatsuo Ishii]

Hi Jesper,

> Hi,
> 
> First my use-case; I need to create the pool_passwd before pgpool is
> started, so I need to use
> 
>  pg_md5 -m -f conf/pgpool.conf -u md5_user md5_password
> 
> which I know is deprecated; I can't use -p, since this a
> non-interactive script. Maybe there should be an option for an input
> file with users / passwords in unencrypted format (user:password).

Sounds an idea.

> Also, I found the
> 
>  pg_md5 -u md5_user md5_password
> 
> command a little confusing, since it output
> 
>  68675fbd5f8a9f03341659489a70944f
> 
> where I was really looking for the line to append to pool_passwd, e.g.
> 
>  md5_user:md545e967027b297f53940769c57cd02768
> 
> Attached is a small documentation patch, but if somebody could explain
> the idea behind and use-cases for the w/o -m case (68675...) then I
> can include that in my patch.

It's used to create pcp.conf which stores a password used by pcp
commands.

> Feedback on this would be appreciated.
> 
> Best regards,
>  Jesper

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp