How to encrypt database password in pgpass or unix file to run batch jobs through shell script

2020-09-25 Thread aditya desai
Hi, We have Amazon RDS Postgres. Currently we are using .pgpass file and running psql from different EC2 instances to connect to DB. But the password in this file is not encrypted. What are our options to encrypt the password? Or do passwordless connection from EC2 to database? Lambda functions hav

Re: How to encrypt database password in pgpass or unix file to run batch jobs through shell script

2020-09-25 Thread Bruce Momjian
On Fri, Sep 25, 2020 at 03:04:56PM +0530, aditya desai wrote: > Hi, > We have Amazon RDS Postgres. Currently we are using .pgpass file and running > psql from different EC2 instances to connect to DB. But the password in this > file is not encrypted. What are our options to encrypt the password? Or