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 |
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 |