From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
---|---|
To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Adding WHERE clause to pg_dump |
Date: | 2008-07-25 15:19:41 |
Message-ID: | 1216999182.3894.930.camel@ebony.2ndQuadrant |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Attached patch implements WHERE clauses for pg_dump.
This is useful for producing data samples of a database
e.g. pg_dump -w "ctid < '(1000,1)' or random() < 0.1"
and can also be used for taking incremental backups, if data columns
exist to make a partial dump sensible.
e.g. pg_dump -w "last_update_timestamp > ...."
Columns such as this are very common because of optimistic locking
techniques in many databases.
This is designed to be used in conjunction with the TOM utility, and the
forthcoming patch to implement stats hooks. Taken together these
features will allow the ability to take a cut-down database environment
for testing, yet with statistics matching the main production database.
It was easier to write it and then discuss, since I needed to check the
feasibility of the idea before presenting it.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
Attachment | Content-Type | Size |
---|---|---|
pg_dump_where.v1.patch | text/x-patch | 8.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Ryan Bradetich | 2008-07-25 15:23:57 | Re: [RFC] Unsigned integer support. |
Previous Message | Alvaro Herrera | 2008-07-25 14:42:03 | Re: Do we really want to migrate plproxy and citext into PG core distribution? |