Storing the password in .pgpass file in an encrypted format

From: firoz e v <firoz(dot)ev(at)huawei(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Storing the password in .pgpass file in an encrypted format
Date: 2014-02-21 12:49:26
Message-ID: 5D90A4A7A6AC31449EDDBE18CD1CD0507C26686B@szxeml521-mbx.china.huawei.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2014-02-21 12:49:37 Re: Patch: show xid and xmin in pg_stat_activity and pg_stat_replication
Previous Message John Williams 2014-02-21 12:44:14 SPI_connect on multi-threaded app