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)?