[GENERAL] exclude user mappings, foreign server from dump

2011-07-06 Thread 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

[GENERAL] user mapping options question

2011-03-16 Thread 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_