Storing the password in .pgpass file in an encrypted format - Mailing list pgsql-hackers

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

 

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Patch: show xid and xmin in pg_stat_activity and pg_stat_replication
Next
From: Szymon Guz
Date:
Subject: Re: Storing the password in .pgpass file in an encrypted format