user mapping options question

From: Sergey Urlin <sergey(dot)urlin(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: user mapping options question
Date: 2011-03-16 13:27:21
Message-ID: AANLkTi=a_P8SiZ37WR9d0JLO=ec20_C-WC3CQUgYxQoj@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I’m using dblink package to execute queries between two postgresql
databases.

Access definitions for the dblink are created using foreign data wrapper,
server and user mappings.

When I set user and password as options then postgres saves these parameters
in four system tables (table pg_user_mapping, view pg_user_mappings,
information_schema: _pg_user_mapping and user_mapping_options) and all
these tables store un-encrypted password.

Is there a way to create user mappings using encrypted passwords or store
the password encrypted in system tables?

Thanks,
Sergey

Browse pgsql-general by date

  From Date Subject
Next Message Igor Neyman 2011-03-16 14:05:25 Re: A join of 2 tables with sum(column) > 30
Previous Message Merlin Moncure 2011-03-16 13:22:03 Re: Postgres 8.3 vs. 8.4 - Query plans and performance