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