Subject: Re: scram-sha-256 encrypted password in pgpass
To: Pavan Kumar <pavan.dba27@gmail.com>,
 Pgsql-admin <pgsql-admin@lists.postgresql.org>,
 pgsql-general@lists.postgresql.org
References: 
 <CA+M0sHEJC6whG8VfNk=393uoDsedQg+tVZ9vy7GLdWBZR5BC0A@mail.gmail.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <9c0675b9-6a4e-8692-2660-c6a37385f2aa@aklaver.com>
Date: Mon, 22 Jun 2020 14:56:19 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
 Thunderbird/68.9.0
MIME-Version: 1.0
In-Reply-To: 
 <CA+M0sHEJC6whG8VfNk=393uoDsedQg+tVZ9vy7GLdWBZR5BC0A@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 8bit
Precedence: bulk

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.klaver@aklaver.com