[GENERAL] exclude user mappings, foreign server from dump

[Sergey Urlin]

Hello,

I have the question regarding pg_dump functionality.
I using PostgreSQL 8.4.8 database and defined the dblink between two
databases. dblink uses foreign data wrapper, user mappings and foreign
server.
When I perform database backup using pg_dump utility it also includes
foreign data wrapper, user mappings and foreign server definitions. However
since it isn't related to the schema itself I would prefer to exclude this
information.

Could you please suggest me if is there a way to not dump foreign data
wrapper and user mappings in pg_dump (exclude this information)?


Thank you.

--
Sergey

[GENERAL] user mapping options question

[Sergey Urlin]

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