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

Поиск
Список
Период
Сортировка
От aditya desai
Тема How to encrypt database password in pgpass or unix file to run batch jobs through shell script
Дата
Msg-id CAN0SRDE14BxP14kL=DMTPrvJYbTpg=9wHYucx+=p1kfmKZnFEw@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to encrypt database password in pgpass or unix file to run batch jobs through shell script  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-performance
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Michael Lewis
Дата:
Сообщение: Re: Single column vs composite partial index
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: How to encrypt database password in pgpass or unix file to run batch jobs through shell script