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

Bo Peng pengbo at sraoss.co.jp
Wed Aug 15 09:18:30 JST 2018


Hi Jesper,

Thank you for your patch.

I modified the patch and commited it.

  https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=383d06e0575ea168b59964a23310651abbcb3850

Also I improved Japanese doc.

On Tue, 14 Aug 2018 10:25:25 +0900
Bo Peng <pengbo at sraoss.co.jp> wrote:

> Thank you for your patch.
> We will test your patch.
> 
> On Fri, 10 Aug 2018 13:52:50 -0400
> Jesper Pedersen <jesper.pedersen at redhat.com> wrote:
> 
> > Hi,
> > 
> > On 08/09/2018 11:02 PM, Tatsuo Ishii wrote:
> > >> 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.
> > > 
> > 
> > Thanks, I have logged that as Issue 422.
> > 
> > >> 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.
> > > 
> > 
> > Thanks - the attached patch tries to expand on the documentation in this 
> > area.
> > 
> > It could be an idea to add support for the "user:md5XXX" syntax in 
> > pcp.conf too. That way the non-md5 syntax could be deprecated, and 
> > pg_md5 would only have to support one format.
> > 
> > I ran into some other issues with pg_md5, but those have been logged 
> > under Bug 419 and Bug 420.
> > 
> > Thanks for considering !
> > 
> > Best regards,
> >   Jesper
> 
> 
> -- 
> Bo Peng <pengbo at sraoss.co.jp>
> SRA OSS, Inc. Japan
> 
> _______________________________________________
> pgpool-hackers mailing list
> pgpool-hackers at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-hackers
> 


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan



More information about the pgpool-hackers mailing list