| From: | Chris Browne <cbbrowne(at)acm(dot)org> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Dump all except some tables? |
| Date: | 2005-10-09 00:36:21 |
| Message-ID: | 60zmpjil16.fsf@dba2.int.libertyrms.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
david(at)fetter(dot)org (David Fetter) writes:
> On Fri, Oct 07, 2005 at 08:21:31PM -0500, Jim C. Nasby wrote:
>> On Fri, Oct 07, 2005 at 02:07:47AM -0700, David Fetter wrote:
>> > On Fri, Oct 07, 2005 at 11:47:26AM +0300, WireSpot wrote:
>> > > But... will the resulting dump be consistent as far as foreign
>> > > keys are concerned? Or will the current -t warning still apply
>> > > (YMMV as to the consistency of the resulting dump)?
>> >
>> > I think the latter is better. This is solidly in the realm of
>> > prying off cover plates, and the warning is already there :)
>>
>> I think it would be good to include an option that only does
>> checking and doesn't actually try to dump anything. That would make
>> it easier to ensure your config file is correct.
>
> Could you flesh this out a bit? What would this option produce in the
> (imho most common) case where dependencies weren't all taken care of?
I'd think that throwing in the "-s" option would allow a meaningful
dry run...
--
let name="cbbrowne" and tld="cbbrowne.com" in name ^ "@" ^ tld;;
http://www.ntlug.org/~cbbrowne/languages.html
Frisbeetarianism: The belief that when you die, your soul goes up on
the roof and gets stuck...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | felix | 2005-10-09 00:49:21 | Re: Oracle buys Innobase |
| Previous Message | Chris Browne | 2005-10-09 00:35:25 | Re: Oracle buys Innobase |