pg_dump --exclude-table-data

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_dump --exclude-table-data
Date: 2011-08-23 20:07:56
Message-ID: 4E54089C.4030708@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Attached is an undocumented patch that allows a user to have pg_dump
exclude data but not DDL for a table. One use case for this is a very
large table that changes infrequently, and for which dumping data
frequently would be wasteful and unnecessary. This is especially useful
in conjunction with another patch (see next email) to do post-data items
only or omit post-data items in pg_restore.

For those who are (like my clients :-) ) anxious to get their hands on
this immediately, a backport patch is also attached which applies to 9.0
sources, and applies with offsets to 8.4 sources.

cheers

andrew

Attachment Content-Type Size
exclude-table-data.patch.90 text/plain 3.9 KB
exclude-table-data.patch text/x-patch 3.9 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2011-08-23 20:08:50 Re: skip WAL on COPY patch
Previous Message Christopher Browne 2011-08-23 19:51:09 Re: Getting rid of pg_pltemplate