Postgres Pro
Downloads
Home   >   mailing lists

Re: Best way to "mask" password in DBLINK - Mailing list pgsql-general

From Tommy Gildseth
Subject Re: Best way to "mask" password in DBLINK
Date
Msg-id 4A826E78.4090703@usit.uio.no
Whole thread Raw
In response to Best way to "mask" password in DBLINK  ("Ow Mun Heng" <ow.mun.heng@wdc.com>)
Responses Re: Best way to "mask" password in DBLINK  ("Ow Mun Heng" <ow.mun.heng@wdc.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Ow Mun Heng"
Date:
Subject: Best way to "mask" password in DBLINK
Next
From: "Ow Mun Heng"
Date:
Subject: Re: Best way to "mask" password in DBLINK