Postgres Pro
Downloads
Home   >   mailing lists

How to encrypt database password in pgpass or unix file to run batch jobs through shell script - Mailing list pgsql-performance

From aditya desai
Subject How to encrypt database password in pgpass or unix file to run batch jobs through shell script
Date
Msg-id CAN0SRDE14BxP14kL=DMTPrvJYbTpg=9wHYucx+=p1kfmKZnFEw@mail.gmail.com
Whole thread Raw
Responses Re: How to encrypt database password in pgpass or unix file to run batch jobs through shell script
List pgsql-performance
Tree view
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 have limitations of running only for 15 minutes.

How can we setup different authentication methods for AWS RDS Postgres as we don't have access pg_hba.conf?

Regards,
Aditya. 

pgsql-performance by date:

Previous
From: Michael Lewis
Date:
Subject: Re: Single column vs composite partial index
Next
From: Bruce Momjian
Date:
Subject: Re: How to encrypt database password in pgpass or unix file to run batch jobs through shell script