Re: [HACKERS] Custom format for pg_dumpall

2004-03-22 Thread Philip Warner
At 03:13 AM 17/03/2004, Bruce Momjian wrote: * Allow pg_dumpall to use non-text output formats Is anyone working on this? Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \

Re: [HACKERS] Custom format for pg_dumpall

2004-03-22 Thread Bruce Momjian
Philip Warner wrote: At 03:13 AM 17/03/2004, Bruce Momjian wrote: * Allow pg_dumpall to use non-text output formats Is anyone working on this? Nope. It was just added to the TODO list. I am working on having pg_dump use SET with_default_oids instead of WITH OIDS, and I have

Re: [HACKERS] Custom format for pg_dumpall

2004-03-16 Thread Bruce Momjian
Added to TODO: * Allow pg_dumpall to use non-text output formats --- Philip Warner wrote: At 11:12 AM 16/03/2004, Tom Lane wrote: That seems like it would complicate both pg_dump and pg_restore unduly. I'd

Re: [HACKERS] Custom format for pg_dumpall

2004-03-15 Thread Bruce Momjian
Christopher Kings-Lynne wrote: Hi, Why is there no custom format dump option for pg_dumpall? What if I want to use pg_dumpall to dump all db's and blobs? Or if I want to have a huge sql dump from which I can easily exract the sql to recreate just one table? I think it is because we

Re: [HACKERS] Custom format for pg_dumpall

2004-03-15 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Christopher Kings-Lynne wrote: Why is there no custom format dump option for pg_dumpall? I think it is because we have no mechanism to merge multiple custom format files from different databases into a single file. Perhaps this is a TODO. It would

Re: [HACKERS] Custom format for pg_dumpall

2004-03-15 Thread Philip Warner
At 02:00 AM 16/03/2004, Tom Lane wrote: Why is there no custom format dump option for pg_dumpall? I think it is because we have no mechanism to merge multiple custom format files from different databases into a single file. That was the main reason (and as Tom suggested, dumpall was a shell

Re: [HACKERS] Custom format for pg_dumpall

2004-03-15 Thread Tom Lane
Philip Warner [EMAIL PROTECTED] writes: I'm envisioning some super-archive format in which there are individual entries containing the pg_dump output for each database Not sure about this. I'd be inclined to investigate just adding another attribute to each TOC entry (database_name). That

Re: [HACKERS] Custom format for pg_dumpall

2004-03-15 Thread Philip Warner
At 11:12 AM 16/03/2004, Tom Lane wrote: That seems like it would complicate both pg_dump and pg_restore unduly. I'd rather keep both of them as simple one-database programs. Sounds fine, if that's a design objective. But it is a different problem to definining the archive format of pg_dumpall.

[HACKERS] Custom format for pg_dumpall

2004-03-14 Thread Christopher Kings-Lynne
Hi, Why is there no custom format dump option for pg_dumpall? What if I want to use pg_dumpall to dump all db's and blobs? Or if I want to have a huge sql dump from which I can easily exract the sql to recreate just one table? Chris ---(end of