Re: scram-sha-256 encrypted password in pgpass

On 6/22/20 1:34 PM, Pavan Kumar wrote:
> Hello expertes,
>
> scram-sha-256 encrypted passwords are supported in .pgpass file ? If yes
> kindly provide us an example.
>
> I am using below format and it is not working for me
>
> /|pglnx1|/:/|5432|/:pgbouncer:/|pgadmin|/:"SCRAM-SHA-256$4096:6IDsjfedwsdpymp0Za7jaMew==$rzSoYL4ZYsW1WJAj7Lt3JtNLNR73AVY7sfsauikweblk][=:Hxx/juPXJZHy5djPctI=*/"/*

You need to use the plain text version of the password like for md5.
Supplying the password via .pgpass is no different from supplying it
from the command line or script.

>
> Please advise
>
> --
> *Regards,
>
> #!  Pavan Kumar
> ----------------------------------------------*-
> *Sr. Database Administrator..!*
> *NEXT GENERATION PROFESSIONALS, LLC*
> *Cell    #  267-799-3182 #  pavan.dba27 (Gtalk) *
> *India   # 9000459083*
>
> *Take Risks; if you win, you will be very happy. If you lose you
> will be Wise *
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com