Re: Best way to "mask" password in DBLINK

From: Tommy Gildseth <tommy(dot)gildseth(at)usit(dot)uio(dot)no>
To: Ow Mun Heng <ow(dot)mun(dot)heng(at)wdc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Best way to "mask" password in DBLINK
Date: 2009-08-12 07:25:44
Message-ID: 4A826E78.4090703@usit.uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ow Mun Heng wrote:
> I'm starting to use DBLink / DBI-Link and one of the "bad" things is that
> the password is out in the clear.
>
> What can I do to prevent it from being such? How do I protect it from
> 'innocent' users?

If I'm not mistaken, it's possible to put your password in the .pgpass
file in the postgres-users home folder, on the server where the postgres
cluster is running.

--
Tommy Gildseth

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ow Mun Heng 2009-08-12 07:30:13 Re: Best way to "mask" password in DBLINK
Previous Message Ow Mun Heng 2009-08-12 02:14:20 Best way to "mask" password in DBLINK