Re: Storing the password in .pgpass file in an encrypted format

On 21 February 2014 13:49, firoz e v <firoz(dot)ev(at)huawei(dot)com> wrote:

> Hi,
>
>
>
> Is there a way to store the password in “.pgpass” file in an encrypted
> format (for example, to be used by pg_dump).
>
>
>
> Even though, there are ways to set the permissions on .pgpass, to disallow
> any access to world or group, the security rules of many organizations
> disallow to hold any kind of passwords, as plain text.
>
>
>
> If there is no existing way to do this, shall we take up this, as a patch?
>
>
>
> Regards,
>
> Firoz EV
>
>
>

And where are you going to keep the passwords to decrypt these passwords
(for example to be used by pg_dump)?

regards,
Szymon