Hi!


since we have a lot of databases here that suffer from pg_dump's 
deficits in 7.3 and 7.4 regarding dependencies, we tried pg_dump from 
the upcoming 7.5 release.
This version works much better, but it is not possible to dump a 
complete cluster using pg_dumpall in a 7.3 or 7.4 compatible way because 
pg_dumpall lacks the "-X disable-dollar-quoting" switch.
Would it be possible to modify pg_dumpall to accept the same commands as 
pg_dump (at least those that make sense) - or am I missing something here ?


thanks


Stefan

Fri, 18 Jun 2004 16:38:29 +0200
Stefan Kaltenbrunner <mm-mailinglist@madness.at>
7.5-dev, pg_dumpall, dollarquoting
Hi Stefan,

> since we have a lot of databases here that suffer from pg_dump's 
> deficits in 7.3 and 7.4 regarding dependencies, we tried pg_dump from 
> the upcoming 7.5 release.

Would you be able to specify exactly the deficiences?  It's my mission 
at the moment to make pg_dump 7.5 known-issue free :)

> This version works much better, but it is not possible to dump a 
> complete cluster using pg_dumpall in a 7.3 or 7.4 compatible way because 
> pg_dumpall lacks the "-X disable-dollar-quoting" switch.
> Would it be possible to modify pg_dumpall to accept the same commands as 
> pg_dump (at least those that make sense) - or am I missing something here ?

I can add it - do the other hackers want it?

The main problem stefan is that 7.5 dump is seriously only guaranteed to 
restore to 7.5.  You can use the 7.5 dump to upgrade to 7.5, but not to 
restore to 7.4.

At the moment, dollar quoting is your main problem, but there's also the 
set default_with_oids stuff, plus I'm also hopefully soon going to fix 
the dumping owners issue, which will most likely make pg_dump 7.5 less 
likely to restore to 7.4...

Chris


Wed, 23 Jun 2004 15:16:47 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: 7.5-dev, pg_dumpall, dollarquoting
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
>> pg_dumpall lacks the "-X disable-dollar-quoting" switch.

> I can add it - do the other hackers want it?

It should be there --- in general pg_dumpall should be able to pass down
any pg_dump switch that makes sense.

			regards, tom lane

Wed, 23 Jun 2004 10:54:58 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: 7.5-dev, pg_dumpall, dollarquoting 
Tom Lane wrote:

>Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
>  
>
>>>pg_dumpall lacks the "-X disable-dollar-quoting" switch.
>>>      
>>>
>
>  
>
>>I can add it - do the other hackers want it?
>>    
>>
>
>It should be there --- in general pg_dumpall should be able to pass down
>any pg_dump switch that makes sense.
>
>
>  
>

Perhaps rather than replicating every pg_dump option pg_dumpall needs a 
single option that can encapsulate them?

e.g.
  --dump-options="--foo --bar --baz"

Just a thought

cheers

andrew


Wed, 23 Jun 2004 11:36:52 -0400
Andrew Dunstan <andrew@dunslane.net>
Re: 7.5-dev, pg_dumpall, dollarquoting
> It should be there --- in general pg_dumpall should be able to pass down
> any pg_dump switch that makes sense.

Do the -S and -O switches also make sense?  Should I add them?

Chris


Fri, 25 Jun 2004 14:22:50 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: 7.5-dev, pg_dumpall, dollarquoting