exclude user mappings, foreign server from dump - Mailing list pgsql-general

From Sergey Urlin
Subject exclude user mappings, foreign server from dump
Date
Msg-id CAOGPgSjGWkSBVC9_qSXkKug9K+07hDSHCTvP1E0JAs5TVafumw@mail.gmail.com
Whole thread Raw
List pgsql-general
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

pgsql-general by date:

Previous
From: Emi Lu
Date:
Subject: ERROR: malformed record literal: "",DETAIL: Missing left parenthesis?
Next
From: John R Pierce
Date:
Subject: Re: Performance Monitoring of PostGRE