scram-sha-256 encrypted password in pgpass

From: Pavan Kumar <pavan(dot)dba27(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: scram-sha-256 encrypted password in pgpass
Date: 2020-06-22 20:34:25
Message-ID: CA+M0sHEJC6whG8VfNk=393uoDsedQg+tVZ9vy7GLdWBZR5BC0A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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=*"*

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 *

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Adrian Klaver 2020-06-22 21:56:19 Re: scram-sha-256 encrypted password in pgpass
Previous Message Adrian Klaver 2020-06-20 04:10:30 Re: create batch script to import into postgres tables

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2020-06-22 20:41:17 Re: DISTINCT on jsonb fields and Indexes
Previous Message Michael Lewis 2020-06-22 20:10:19 Re: DISTINCT on jsonb fields and Indexes